Run Code
|
API
|
Code Wall
|
Users
|
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
Please
log in
to post a comment.
Join elements by key with json fields
test
simple add function on sql
Comp
quiz 1
Full text search
JieShenLaiOfferSQL
mandelbrot set
Professional Networking Social Media Website SQL Analysis
sample
Please log in to post a comment.