![]() ![]() ![]() B) Using CASE with an aggregate function example Note that we placed a column alias duration after the CASE expression. ORDER BY title Code language: PHP ( php ) WHEN length> 0 AND length 50 AND length 120 THEN 'Long' To apply this logic, you can use the CASE expression in the SELECT statement as follows: SELECT title,
0 Comments
Leave a Reply. |