habr.com

  www.youtube.com

  murcode.ru

SELECT first_name, last_name, CASE WHEN TIMESTAMPDIFF(YEAR, birthday, NOW()) >= 18 THEN "Совершеннолетний" ELSE "Несовершеннолетний" END AS status FROM Student. CASE 2 WHEN 0 THEN "Ноль" WHEN 1 THEN "Один" ELSE "Много" END.

  sql-academy.org

  trepsy.net

  stackoverflow.com

Example 2: CASE WHEN With ELSE in GROUP BY. You would define the first two population levels and then use ELSE to bucket every other city into high.

  learnsql.com

  hibridge.kz

  dba.stackexchange.com

  pastebin.com

Page generated - 0.1454219818 (7a2f20bef0ec45ab7dd7c2899a265f1d)