Database - Introduction to SQL - Discussion
Discussion Forum : Introduction to SQL - General Questions (Q.No. 3)
3.
The SQL WHERE clause:
Discussion:
27 comments Page 1 of 3.
Gowri said:
8 months ago
WHERE clause is used to retrieve row-level data from the table, based on the condition.
For example.
Select * from employees where emp_salary>10000.
Here the employee is a table name.
emp_salary is a column name.
The answer displays the rows only which that have > than 10000.
For example.
Select * from employees where emp_salary>10000.
Here the employee is a table name.
emp_salary is a column name.
The answer displays the rows only which that have > than 10000.
Santhosh said:
1 year ago
Where Clause comes under selection.
In selection we can select rows only.
In selection we can select rows only.
Trupti said:
1 year ago
The SQL WHERE clause limits the row data that are returned. We limit column data only in the first select clause.
Karthi said:
5 years ago
The where clause is used to check the condition.
Based on the condition, we can select some specific records from the table and we can update some specific records in the table, and also we can delete some specific records from the table.
Based on the condition, we can select some specific records from the table and we can update some specific records in the table, and also we can delete some specific records from the table.
Sanjib said:
7 years ago
Where clause is used to invoke index.
Pauline said:
8 years ago
Where clause specifies which records should be updated. E.g give me all the records of all the students who are 18 yrs. The WHERE clause is synonymous to"who are 18 yrs".
Sat said:
8 years ago
Anyone please tell me about column restriction? How is it possible with example?
Shibani said:
8 years 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?
Kuntee kurre said:
8 years 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:
8 years ago
What is the difference between SQL and ORACLE?
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers