The result of below statement will be - Select * from employee where EMPID = 100 AND CITY = "NEW YORK"
All Employees data
Employees data whose employee ID is 100 and City is NEW YORK
Employees data whose employee ID is either 100 or city is NEW YORK
Employees data whose employee ID lies between 1000 and 100 and city is NEW YORK