Guest User

Untitled

a guest
Apr 20th, 2018
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.30 KB | None | 0 0
  1. SELECT
  2.  
  3. t.category,
  4. t.title,
  5. t.created
  6.  
  7. FROM
  8.  
  9. entries AS t
  10.  
  11. INNER JOIN mymax AS m ON m.category = t.category AND m.maxdate = t.created
  12.  
  13.  
  14. SELECT
  15.  
  16. t.category,
  17. t.title,
  18. t.created
  19.  
  20. FROM
  21.  
  22. entries AS t
  23.  
  24. INNER JOIN mymax AS m ON m.category = t.category
  25.  
  26. WHERE
  27.  
  28. m.maxdate = t.created
Add Comment
Please, Sign In to add comment