Database - Introduction to SQL - Discussion
Discussion Forum : Introduction to SQL - General Questions (Q.No. 3)
3.
The SQL WHERE clause:
Discussion:
28 comments Page 2 of 3.
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.
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';
Iftikhar said:
2 decades ago
Please Explain. I have Doubt.
Rahul kumar said:
1 decade ago
Actually the WHERE clause is used to extract only those data's that fulfills a specified criterion. It is used on row operation. E.g:
SELECT column_name(s)
FROM table_name
WHERE column_name sal value
SELECT column_name(s)
FROM table_name
WHERE column_name sal value
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.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers