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.
Manche Shekhar said:
1 decade ago
By using where clause we can retrive the records which are satisfied the conditions...
Raku said:
1 decade ago
View is used to limit the column.
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.
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
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.
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';
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.
Adane said:
1 decade ago
What is the difference between SQL and ORACLE?
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.
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?
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers