Run Code
|
API
|
Code Wall
|
Users
|
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
Please
log in
to post a comment.
Assignment 1(SET A)
PostreSQL: warehouse table
loggin_trigger-audit
PostgreSQL: CASE
Assignment 1(SET A)
Select the latest id from last week from each different contact without repeating barcodes .....
Mandelbrot
Select all countries that can be found by recursively adding all neighbouring countries (PostgreSQL)
FInale 38474297439
sss
Please log in to post a comment.