SELECT DISTINCT to_char(t.created_date, 'YYYY-MM-dd') m, COUNT(t.id) OVER (PARTITION BY date(t.created_date)) total FROM

Question

table t;
ребят как сортировать по дате?

0

13.07.2021

15 просмотров

SELECT to_char(t.created_date, 'YYYY-MM-dd') m, COUNT(t.id) total FROM table t GROUP BY 1 ORDER BY t.created_date;

0

13.07.2021

[42803] ERROR: column "t.created_date" must appear in the GROUP BY clause or be used in an aggregate function

0

13.07.2021

SELECT to_char(t.created_date::date, 'YYYY-MM-dd') m, COUNT(t.id) total FROM table t GROUP BY t.created_date::date ORDER BY t.created_date::date;

0

13.07.2021

или SELECT to_char(oiu.created_date, 'YYYY-MM-dd') m, COUNT(oiu.id) total FROM one_id_user oiu GROUP BY 1 ORDER BY 1 desc

0

13.07.2021

Аноним · Accepted Answer

order by 1

0

13.07.2021