Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
finaleHFEIZFIDSHI
--PostgreSQL 9.6 --'\\' is a delimiter CREATE SCHEMA erp; CREATE TABLE erp.orders( userId integer, paidat timestamp DEFAULT current_timestamp ); INSERT INTO erp.orders VALUES ('2','2017-01-01' ), ('3','2017-01-01' ), ('2','2017-01-01' ), ('2','2017-01-01' ), ('4','2017-06-07' ), ('2','2017-06-07' ), ('1','2017-06-30' ), ('1','2017-06-18' ), ; select distinct erp.orders.paidat from erp.orders;
run
|
edit
|
history
|
help
0
histogram to percentiles
pokemo
user
PostgreSQL pivot using temp view
testo
complicated-conditional-sql-query-to-match-attributes-for-marketing-campaigns/43219741#43219741
Pivot the Hard Way.
Demo
test_tags_count
Return IDs where there are exactly 3 occurrences