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
Returning IDs with exactly 3 consecutive months of invoice_amt >2000
Branch
a
Christmas Tree Generator
G.Giftcard Interview Analysis Conducted by Miranda Zhao
Cross Tab With Totals
1
1
FINALE fdjfnkds
Query for matching substring from text field in DB