Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
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.
nested array to table
test jsonb_set of PostgreSQL
tegs and users
CALCULATOR USING PL/PGSQL FUNCTIONS
sql
remove properties from jsonb using function jsonb_set of PostgreSQL
Pivot the Hard Way..
SQL3
loggin_trigger-audit
Replace key of json
Please log in to post a comment.