Run Code
|
API
|
Code Wall
|
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
remove duplicated rows
Items
BC160401693
SQL Server Rank Query Optimization
Primary key and unique key for single column and multi columns
stackoverflow_mysql_demo_data
test
Viernes
QLSV
Crea, inserta y confirma tabla