pasumpon Starting Member
1 Posts
sunitabeck Flowing Fount of Yak Knowledge
5152 Posts
SELECT * FROM ( VALUES (1),(2),(3),(4)) t(emp_id) WHERE NOT EXISTS (SELECT * FROM Employee e WHERE e.emp_id = t.emp_id)
sodeep Flowing Fount of Yak Knowledge
USA 7173 Posts
Select E.Id from Employee E Where emp_id in (1,2,3,4) and NOT Exists (Select * from Employee Where emp_id = E.emp_id)
sql query help
Posted - 11/28/2012 : 08:58:39
