Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
SQL - Unpivot Table
with t(id ,loc , val1 ,val2 ,val3 ,val4) as ( select 1 ,'loc1' , 10 ,190 ,null , 20 union all select 2 ,'loc2' , 20 ,null ,10 , 10 ) SELECT * FROM ( select id, loc, val1 as val from t a UNION ALL select id, loc, val2 as val from t a UNION ALL select id, loc, val3 as val from t a UNION ALL select id, loc, val4 as val from t a ) x order by ID
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
Q4
Query integer in text field - Seemingly doesn't work as expected
PostreSQL: Today's Date/Time
select from json[]
Select the latest id from last week from each different contact without repeating barcodes.....
Tememons Dashboard
Assignment 1(SET A)
SQL2_CLASS
Persy_Jackson
w3c sql data
Please log in to post a comment.