Advertisement
smaction

Results do not order as selected.

Feb 11th, 2015
249
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.19 KB | None | 0 0
  1. SELECT
  2. GROUP_CONCAT(employee_group_id)
  3. , COUNT(employee_group_data_id) AS 'GroupCount'
  4. , user_id
  5. FROM clientbackend_dev.employee_group_data
  6. GROUP BY
  7. user_id
  8. ORDER BY
  9. 'GroupCount' DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement