Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --6.11
- SELECT top 1 boeken.cat_id,Categorie.categorie, count(boeken.cat_id) as [aantal boeken per categorie] from Boeken,Categorie
- where Boeken.cat_id = Categorie.cat_id
- group by Boeken.cat_id,Categorie.categorie
- order by [aantal boeken per categorie] desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement