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