Boolean in SELECT
Create true/false columns.
sql
1SELECT name, marks,
2 marks >= 80 AS passed
3FROM students;Returns 1 (true) or 0 (false).

Create true/false columns.
1SELECT name, marks,
2 marks >= 80 AS passed
3FROM students;Returns 1 (true) or 0 (false).