Database - Introduction to SQL - Discussion
Discussion Forum : Introduction to SQL - General Questions (Q.No. 3)
3.
The SQL WHERE clause:
Discussion:
27 comments Page 2 of 3.
Himani Agarwal said:
1 decade ago
How can where puts a limitation on column it can only check for the conditions and display rows accordingly. The columns can only be specified with select clause.
Shibani said:
1 decade ago
Can we write the syntax as:
select 'ename' from records where salary>260000;
Where records is table name and ename is employee name why not?
select 'ename' from records where salary>260000;
Where records is table name and ename is employee name why not?
BrahmmiSoft said:
1 decade ago
Where basically used to filter Records(Rows).
select * from emp where ename='smith';
So, Here we are putting Restriction on the rows only.
select * from emp where ename='smith';
So, Here we are putting Restriction on the rows only.
Kuntee kurre said:
1 decade ago
Where clause is used to limit the row. If I want to display only those student name who achieve greater than 80 then we limit the row.
Trupti said:
4 years ago
The SQL WHERE clause limits the row data that are returned. We limit column data only in the first select clause.
Jyoti said:
1 decade ago
Because in where clause we use the condition on the row tuple and not on the coloum. So b is correct ans.
ASHISH PRAJAPATI said:
1 decade ago
Where clause provoide restriction such as how many row are retrive that specify by where clause.
Manche Shekhar said:
1 decade ago
By using where clause we can retrive the records which are satisfied the conditions...
Sat said:
1 decade ago
Anyone please tell me about column restriction? How is it possible with example?
Santhosh said:
4 years ago
Where Clause comes under selection.
In selection we can select rows only.
In selection we can select rows only.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers