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
book suggestion
E-Commerce SQL Analysis by Ran Li
test
Transform sequential key value data to row based key value data
Movie Rating SQL Analysis Project
Ecommerce Website Analysis by SQL
cte
prec
PostreSQL: warehouse table
postgresql select test