Database - Introduction to SQL - Discussion
Discussion Forum : Introduction to SQL - General Questions (Q.No. 3)
3.
The SQL WHERE clause:
Discussion:
27 comments Page 3 of 3.
Sat said:
1 decade ago
Anyone please tell me about column restriction? How is it possible with example?
Pauline said:
1 decade 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".
Sanjib said:
9 years ago
Where clause is used to invoke index.
Karthi said:
7 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.
(1)
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.
Santhosh said:
4 years ago
Where Clause comes under selection.
In selection we can select rows only.
In selection we can select rows only.
Gowri said:
3 years 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.
(9)
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers