Sunday, 10 February 2013

SQL WHERE Clause Syntax and Examples

SQL WHERE Clause 
The WHERE clause is used to extract the Records which fulfill a specified condition

Syntax

SELECT column_name(s) FROM table_name WHERE column_name operator value

Example:

Suppose we have an EMP Table as follows :
Emp_ID
E_Name
Job
Dept_ID
Salary
1001
Ravi Teja Reddy
Analyst
1
20000
1002
Karun
Team Lead
2
35000
1003
Ravi Kumar Rao
Analyst
1
10000
1004
Tamatam
Team Lead
3
25000
1005
Sai Kumar Teja
Analyst
2
15000
1006
William
Manager
3
50000
1007
Vikram Teja Reddy
Analyst
2
18000
1008
Varun
Team Lead
1
33000
1009
Smith
Team Lead
3
50000

---------------------------------------------------------------------------------------------------------
Criteria - I :
Extracting records from above Table where Job = 'Analyst'


Select*from EMP WHERE Job='Analyst'

Result :
Emp_ID
E_Name
Job
Dept_ID
Salary
1001
Ravi Teja Reddy
Analyst
1
20000
1003
Ravi Kumar Rao
Analyst
1
10000
1005
Sai Kumar Teja
Analyst
2
15000
1007
Vikram Teja Reddy
Analyst
2
18000

---------------------------------------------------------------------------------------------------------
Criteria - II :
Extracting records from above Table where Emp_Id IN(1002,1004,10016)


Select*from EMP WHERE Emp_ID IN(1002,1004,10016)

Result :
Emp_ID
E_Name
Job
Dept_ID
Salary
1002
Karun
Team Lead
2
35000
1004
Tamatam
Team Lead
3
25000
1006
William
Manager
3
50000

Note:
 In some versions of SQL the <> operator may be written as !=

1 comment:

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts