sql query

Below query will provide you the employee located in delhi and noida and the ID is either 4 or 5.

select EmployeeName,EmployeeID,City from Employee where EmployeeID in (4,5) and City in ('Delhi','Noida')

Cheers,
Venkatesan Prabu .J

manoj kumar16y ago

Sorry sir.. I was ask Kirtan patel..
Your query is work fine bt not give all list record.it's query give me only one record.

Crish16y ago

I am not getting you , what you are saying ?

manoj kumar16y ago

Thanks sir..
your query work is fine, bt this is not correct result. Iwas ask EmployeeId should be mentan where clause..how it possible.

Crish16y ago

hi

try below query...

select EmployeeName,EmployeeID,City from Employee where EmployeeID in (4,5) and City in ('Delhi','Noida')

Don't forget to Mark Do you like this Answer
that solved your problem!

Kirtan Patel16y ago

Corrected Query

Exported from Notepad++

select * from select EmployeeName,EmployeeID,City from Employee where EmployeeID= 4 or EmployeeId=5
 where City='Delhi' or City='Noida' 