Guest User

Untitled

a guest
Oct 22nd, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.15 KB | None | 0 0
  1. SELECT Eid, Count(Eid),
  2. (SELECT Ename from Employee where Employee.Eid = Assignment.Eid) as EName
  3. FROM Assignment
  4. GROUP BY Eid HAVING Count(Eid) > 1;
Add Comment
Please, Sign In to add comment