Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Lisber-SQL-Example(CASE)
SELECT a.* INTO #lisber FROM ( SELECT 1 as 'id' UNION ALL SELECT 0 as 'id' UNION ALL SELECT 0 as 'id' UNION ALL SELECT 1 as 'id' UNION ALL SELECT 1 as 'id' UNION ALL SELECT 1 as 'id' UNION ALL SELECT 1 as 'id' UNION ALL SELECT 0 as 'id' UNION ALL SELECT 0 as 'id' UNION ALL SELECT 0 as 'id' UNION ALL SELECT 1 as 'id' UNION ALL SELECT 0 as 'id' UNION ALL SELECT 1 as 'id' UNION ALL SELECT 0 as 'id' UNION ALL SELECT 1 as 'id' UNION ALL SELECT 0 as 'id' UNION ALL SELECT 1 as 'id' ) as a SELECT CASE a.id WHEN 0 THEN a.id+2 WHEN 1 THEN a.id+3 END as 'changedId' FROM #lisber a DROP TABLE #lisber
run
|
edit
|
history
|
help
0
Preppin Data Challenge - Week 8
Doc
string conversion
table emp
1512081 QUAN LY DE TAI
QUAN LY CHUYEN BAY
service_delivery_task
SQL for beginners( defined with errors while enforcing constraints)
ex2
28-02 3