Advertisement
Guest User

Untitled

a guest
Sep 21st, 2017
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.93 KB | None | 0 0
  1. SELECT        sr.dossier_id, sr.vaardigheid, sr.niveau, sr.TYPE, COUNT(sr.snijpunt_reken_id)
  2. FROM          snijpunt_reken sr
  3. WHERE         sr.snijpunt_reken_id NOT IN(
  4.     SELECT oe.snijpunt_id
  5.     FROM onderwijsproduct_eisen oe
  6. )
  7. GROUP BY      sr.dossier_id, sr.vaardigheid, sr.niveau, sr.TYPE
  8. HAVING COUNT  (sr.snijpunt_reken_id)> 1
  9. ORDER BY      sr.dossier_id, sr.TYPE, sr.vaardigheid, sr.niveau
  10.  
  11. ## The ONLY thing missing ##
  12. IF there IS NO MATCH IN the "NOT IN" clause i can IGNORE the MIN(sr.snijpunt_reken_id) since the TABLE needs 1 VALUE BY DEFAULT.
  13.  
  14. ## Example ROWS
  15. snijpunt_reken_id   dossier_id  vaardigheid niveau  TYPE
  16. 8827            367     verhoudingen    3F  MEIJERINK
  17. 15757           367     verhoudingen    3F  MEIJERINK
  18. 26239           367     verhoudingen    3F  MEIJERINK
  19. 19365           367     verhoudingen    3F  MEIJERINK
  20. 15755           367     verbanden   3F  MEIJERINK
  21. 8825            367     verbanden   3F  MEIJERINK
  22. 19363           367     verbanden   3F  MEIJERINK
  23. 26237           367     verbanden   3F  MEIJERINK
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement