Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
StackOverflow_53753663
CREATE TABLE myTable (id int, idnew int) ; INSERT INTO myTable (id, idnew) VALUES (1, 2), (3, 4), (2, NULL), (4, 7), (6, 8), (7, NULL) ; SELECT * FROM myTable; SELECT mixed_id FROM ( SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS row_num, id, idnew FROM myTable ) AS x UNPIVOT ( mixed_id for item in (id, idnew) ) AS y WHERE mixed_id IS NOT NULL ORDER BY row_num, mixed_id ;
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
2021-03-23_LeetCodeSQL
InsertData.sql
bc160401693
3r3r
BRYAN_BD Actul
Función Borrar carácter inicial repetido
Fff
Cine Latinoamericano
Insert multiple parent-child records
Create Date Batches from Date Range - SQL Server
Please log in to post a comment.