Where condition In Sql

SQL Where Condition

1. Get employee details from employees table whose employee name is “King”

Select * from EMPLOYEES where last_NAME='King'

2. Get employee details from employees  table whose employee name are “John” and “Roy”

Select * from EMPLOYEES where FIRST_NAME in ('King','Kochhar')

3. Get employee details from employee table whose employee name are not “John” and “Roy”

Select * from EMPLOYEES  where Last_NAME not in ('King','Kochhar')

Share this

Hemalata