Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
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
Persy_Jackson
code1
mandelbrot set
PostreSQL: Full Outer Join
1
as
1280. Students and Examinations
funkcia_transakcie
nasa2
PostreSQL: CASE