SQL Greater Than or Equal To Comparison Operator

The SQL Greater Than or Equal To comparison operator (>=) is used to compare two values.  It returns TRUE if the first value is greater than or equal to the second.  If the second is greater, it returns FALSE. 

You can also test for greater than or equal to by using >=.  

Here are a couple of examples: 

Here is an example using the SQL greater than or equal to comparison operator to find all products whose list price is $3000 or more:

Only rows having a ListPrice equal to or more than $3000.00 are included in the result. Try it for yourself!

SELECT ProductNumber, Name, ListPrice
FROM   Production.Product
WHERE  ListPrice >= 3000

SQL Greater Than or Equal To with Other Types 

You can use the SQL greater than or equal to comparison with other data types, such as VARCHAR and DATETIME. 

Here we’re returning products modified after February 1^st, 2014.

SELECT ProductNumber, Name, ListPrice, ModifiedDate
FROM   Production.Product
WHERE  ModifiedDate >= '2014-02-01'

Additional Resources 

To learn more about SQL greater than or equal to (>=), check out these useful resources: 

• SQL WHERE – Guide and Examples
• SQL Less Than or Equal To Comparison Operator