SQL Server - Greater than or equal to (>=) Operator

The SQL Server (Transact-SQL) >= (greater than or equal to) operator checks if the value of left operand is greater than or equal to the value of right operand and returns true if the condition is true, false otherwise.

Syntax

The syntax for using greater than or equal to operator in SQL Server (Transact-SQL) is given below:

expression >= expression  

Parameters

Example:

Consider a database table called Employee with the following records:

To select records of table where Age of the person is greater than or equal to 27, the query is given below.

SELECT * FROM Employee
WHERE Age >= 27;

The query will produce following result: