Simple CASE WHEN command : CASE WHEN Select « Flow Control « SQL / MySQL

1. SQL / MySQL
2. Flow Control
3. CASE WHEN Select

Simple CASE WHEN command

SELECT CASE WHEN 10*2=30 THEN '30 correct'
   WHEN 10*2=40 THEN '40 correct'
   ELSE 'Should be 10*2=20'
END;



           
       

Related examples in the same category