Monday, 24 August 2015

Write a query to display employee name whose not assign any product table.

Table Name: Emp

EmpIdName
1Sagar
2Raj
3Mohan
4Anand
5Tiku

Table Name:  Product

ProductIdEmpIdProductName
11Product1
21Product2
32Product3
43Product4
55Product5



SELECT Empid, name FROM Emp e
WHERE NOT EXISTS
(
         SELECT * FROM Product AS p WHERE p.empid = e.empid
)

No comments:

Post a Comment