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.
Adane said:
1 decade ago
What is the difference between SQL and ORACLE?
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.
Arati said:
1 decade ago
The WHERE clause is used to extract only those records that fulfill a specified criterion.
Eg: customers from the country "India", in the "Customers" table
SELECT * FROM Customers
WHERE Country='India';
Eg: customers from the country "India", in the "Customers" table
SELECT * FROM Customers
WHERE Country='India';
Gourav agrawal said:
1 decade ago
WHERE basically used to filter Records(Rows).
when we write,
select * from student where city='Indore'
So, Here we are putting Restriction on the rows of a column city.
when we write,
select * from student where city='Indore'
So, Here we are putting Restriction on the rows of a column city.
Iftikhar said:
1 decade ago
Please Explain. I have Doubt.
Vani said:
1 decade ago
Where class is used to retrieve row data from the table.
Suppose we have a one emp table that contains some columns if we want get the information of empid 234 so we have to write,
SELECT * from emp where Empid=234.
Suppose we have a one emp table that contains some columns if we want get the information of empid 234 so we have to write,
SELECT * from emp where Empid=234.
Raku said:
1 decade ago
View is used to limit the column.
Manche Shekhar said:
1 decade ago
By using where clause we can retrive the records which are satisfied the conditions...
Shilpashree said:
1 decade ago
In where clause we use the condition on the row tuple.
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.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers