Guest User

Untitled

a guest
Jul 21st, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.30 KB | None | 0 0
  1. SELECT products.user_id, products.created
  2. FROM (
  3.  
  4. SELECT user_id, created, IF( @prev <> user_id, @rownum :=1, @rownum := @rownum +1 ) AS rank, @prev := user_id
  5. FROM products t
  6. JOIN (
  7.  
  8. SELECT @rownum := NULL , @prev :=0
  9. ) AS r
  10. ORDER BY t.user_id
  11. ) AS products
  12. WHERE products.rank <=2
  13. ORDER BY created
Add Comment
Please, Sign In to add comment