Run Code
|
Code Wall
|
Users
|
Misc
|
Feedback
|
About
|
Login
|
Theme
postgres group by by function
create table newsfeed ( last_create_date date, s int ); insert into newsfeed values ( '2018-10-10', 1); select to_char(last_create_date, 'YYYYmm') as "test", count (s) as "total" FROM newsfeed group by to_char(last_create_date, 'YYYYmm') order by to_char(last_create_date, 'YYYYmm')
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
Distinct row aggregation with ordering - stackoverflow.com/q/43249053/4116017
Conditional Cross Join - Why doesn't this work on the 'ON' clause?
IF IN POSTGRESQL
Postgres Practice
funkcia_transakcie
Stack
histogram to percentiles
loggin_trigger-audit
PostgreSQL pivot using temp view
Funciones matemáticas PostgreSQL
Please log in to post a comment.