Greater Than or Equal To
The >= operator includes the boundary value.
Syntax
sql
1SELECT * FROM students WHERE marks >= 80;Example
Find students with 80 marks or higher:
sql
1SELECT * FROM students
2WHERE marks >= 80;Comparison
| Query | Includes 80? |
|---|---|
marks > 80 | No |
marks >= 80 | Yes |
More Examples
sql
1-- Students 14 or older
2SELECT * FROM students WHERE age >= 14;
3
4-- Marks 90 and above
5SELECT * FROM students WHERE marks >= 90;