Advertisement
nocturnalmk

Untitled

Apr 20th, 2013
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.27 KB | None | 0 0
  1. SELECT course_id FROM
  2.  (SELECT course_id, COUNT(*) AS zapisuvanja FROM enroll GROUP BY (course_id) ORDER BY zapisuvanja DESC)
  3. WHERE
  4.  zapisuvanja = (SELECT zapisuvanja FROM (SELECT MAX(COUNT(*)) AS zapisuvanja FROM enroll GROUP BY (course_id) ORDER BY zapisuvanja DESC))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement