The SQL Greater Than comparison operator (>) is used to compare two values. It returns TRUE if the first value is greater than 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:
|10 > 5||TRUE|
|5 > 20||FALSE|
|10 > 10||FALSE|
Here is an example using the SQL greater than comparison operator to find all products whose list price is greater than $3000:
SELECT ProductNumber, Name, ListPrice From Production.Product Where ListPrice > 3000
SQL Greater Than with Other Types
Here we’re returning products modified after February 1st, 2014.
SELECT ProductNumber, Name, ListPrice, ModifiedDate From Production.Product WHERE ModifiedDate > '2014-02-01'
To learn more about SQL greater than (>), check out these useful resources: