Guest User

Запрос с условием аггрегирования

a guest
May 31st, 2017
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.04 KB | None | 0 0
  1. Исходные данные
  2. id | title | source | category | published_on
  3. ----+-------+--------+----------+--------------
  4. 1 | n1 | s1 | c1 | 2017-03-24
  5. 2 | n2 | s1 | c1 | 2017-03-29
  6. 3 | n3 | s1 | c1 | 2017-05-15
  7. 4 | n4 | s1 | c2 | 2017-04-12
  8. 5 | n5 | s1 | c1 | 2017-02-14
  9. 6 | n6 | s1 | c1 | 2017-04-16
  10. 7 | n7 | s1 | c1 | 2017-04-23
  11. 8 | n8 | s1 | c2 | 2017-02-02
  12. 9 | n9 | s2 | c1 | 2017-05-03
  13. 10 | n10 | s2 | c1 | 2017-05-12
  14. 11 | n11 | s2 | c2 | 2017-04-14
  15. 12 | n12 | s2 | c2 | 2017-03-16
  16. 13 | n13 | s2 | c2 | 2017-05-10
  17. 14 | n14 | s2 | c2 | 2017-03-10
  18. 15 | n15 | s2 | c3 | 2017-04-11
  19. 16 | n16 | s3 | c3 | 2017-04-01
  20. 17 | n17 | s3 | c4 | 2017-03-26
  21. 18 | n18 | s4 | c2 | 2017-02-13
  22. 19 | n19 | s5 | c1 | 2017-03-08
  23.  
  24. Результат решения задачи (отобранные записи с одного источника максимум 5 записей из категорий c1 и c2 по возрастанию published_on), из остальных категоий любое количество.
  25. id | title | category | source | published_on
  26. ----+-------+----------+--------+--------------
  27. 1 | n1 | c1 | s1 | 2017-03-24
  28. 2 | n2 | c1 | s1 | 2017-03-29
  29. 3 | n3 | c1 | s1 | 2017-05-15
  30. 6 | n6 | c1 | s1 | 2017-04-16
  31. 7 | n7 | c1 | s1 | 2017-04-23
  32. 9 | n9 | c1 | s2 | 2017-05-03
  33. 10 | n10 | c1 | s2 | 2017-05-12
  34. 11 | n11 | c2 | s2 | 2017-04-14
  35. 12 | n12 | c2 | s2 | 2017-03-16
  36. 13 | n13 | c2 | s2 | 2017-05-10
  37. 15 | n15 | c3 | s2 | 2017-04-11
  38. 16 | n16 | c3 | s3 | 2017-04-01
  39. 17 | n17 | c4 | s3 | 2017-03-26
  40. 18 | n18 | c2 | s4 | 2017-02-13
  41. 19 | n19 | c1 | s5 | 2017-03-08
Add Comment
Please, Sign In to add comment