Guest User

Untitled

a guest
Apr 22nd, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.21 KB | None | 0 0
  1. SELECT PimsUser,
  2.     COUNT(PimsUser) AS NumOccurrences, (SELECT PersID FROM atbv_personell_Ansatte AS AA WHERE AA.PersID=A.PersID)
  3.     FROM atbv_personell_Ansatte AS A
  4.     GROUP BY PimsUser
  5.     HAVING ( COUNT(PimsUser) = 1)
Add Comment
Please, Sign In to add comment