Knowledge Walls
Gopal Rao
Mumbai, Maharashtra, India
Passcode:
Where condition in sql query in Queries of SQL Queries
2242 Views
Hints 
Where condition used in the select statement.When you need to compare the column which has some values where condition used.

In following example, emp numbers are selected where the job column has value of clerk in work_on table.Can use "and","or" with where condition to check multiple columns values.
Syntax
select columnName from tableName where columnName ='value';
Example
Get the employee numbers for all clerks

select emp_no from Works_on where job='Clerk';
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details