Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT sr.dossier_id, sr.vaardigheid, sr.niveau, sr.TYPE, COUNT(sr.snijpunt_reken_id)
- FROM snijpunt_reken sr
- WHERE sr.snijpunt_reken_id NOT IN(
- SELECT oe.snijpunt_id
- FROM onderwijsproduct_eisen oe
- )
- GROUP BY sr.dossier_id, sr.vaardigheid, sr.niveau, sr.TYPE
- HAVING COUNT (sr.snijpunt_reken_id)> 1
- ORDER BY sr.dossier_id, sr.TYPE, sr.vaardigheid, sr.niveau
- ## The ONLY thing missing ##
- 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.
- ## Example ROWS
- snijpunt_reken_id dossier_id vaardigheid niveau TYPE
- 8827 367 verhoudingen 3F MEIJERINK
- 15757 367 verhoudingen 3F MEIJERINK
- 26239 367 verhoudingen 3F MEIJERINK
- 19365 367 verhoudingen 3F MEIJERINK
- 15755 367 verbanden 3F MEIJERINK
- 8825 367 verbanden 3F MEIJERINK
- 19363 367 verbanden 3F MEIJERINK
- 26237 367 verbanden 3F MEIJERINK
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement