Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
conditionally add “another row” in SQL Server?
SELECT CASE WHEN arg = '1' THEN unnest(ARRAY[my_row,'another row']) ELSE my_row END FROM ( SELECT 0 arg, 'apples' my_row UNION ALL SELECT 0 arg, 'oranges' my_row UNION ALL SELECT 1 arg, 'pears' my_row UNION ALL SELECT 0 arg, 'dates' my_row ) t
run
|
edit
|
history
|
help
0
PostreSQL: Left Join
3c
Leet Code 185
test
Pedido
Professional Networking Social Media Website SQL Analysis
Pivot the Hard Way..
xD
extract_pairs
Movie Rating SQL Analysis Conducted by Miranda Zhao