CASE Expression in MySQL

CASE — IF/ELSE in SQL

Grade from Marks

SELECT name, marks,
  CASE
    WHEN marks >= 90 THEN 'A+'
    WHEN marks >= 75 THEN 'A'
    WHEN marks >= 33 THEN 'Pass'
    ELSE 'Fail'
  END AS grade
FROM students;

Summary

• CASE WHEN ... THEN ... ELSE ... END picks output by condition.
• Great for grades, labels and categories inside a query.

CASE — SQL में IF/ELSE

Marks से Grade

SELECT name, marks,
  CASE
    WHEN marks >= 90 THEN 'A+'
    WHEN marks >= 75 THEN 'A'
    WHEN marks >= 33 THEN 'Pass'
    ELSE 'Fail'
  END AS grade
FROM students;

सारांश

• CASE WHEN ... THEN ... ELSE ... END condition से output चुनता है।
• Query के अंदर grades, labels और categories के लिए बढ़िया।