SQL Greater Than Comparison Operator

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 > 5TRUE 
5 > 20FALSE
10 > 10FALSE

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 
SELECT ProductNumber, Name, ListPrice 
From Production.Product 
Where ListPrice > 3000

SQL Greater Than with Other Types 

You can use the greater than comparison with other data types, such as String and DateTime. 

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

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

Additional Resources 

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

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Are YOU READY TO START LEARNING SQL SERVER, BUT DON'T KNOW WHERE TO START?

Nothing is worse than, being excited to learn a new tool but not knowing where to start, wasting time learning the wrong features, and being overwhelmed .

But it doesn't have to be this way.

I'm Putting together a free email course to help you get started learning SQL Server.

Name*
Email*
Sign Up
>