SQL Less Than Comparison Operator

By: Kris Wenzel   |   Updated: March 6, 2022  
Works With: 

The SQL Less Than comparison operator (<) is used to compare two values.  It returns TRUE if the first value is less than the second.  If the second is less, it returns FALSE. 

You can also test for Less than or equal to by using <=.  

Here are a couple of examples: 

10 < 5FALSE
5 < 20TRUE
10 < 10FALSE

Here is an example using SQL Less than comparison operator to find all products with a ListPrice under $100.00

SQL Less Than Example

Only rows having a list prices less than $100.00 are included in the result. Now try it for your self!

SQL Less Than with Other Types 

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

Here we’re returning products modified before February 15th, 2014. 

When working with text values, such as names and address, keep in mind your DBMS collating order. It will affect how these operators work. In simple terms the collating order is (A-Z) ascending, but you can can that!

Additional Resources 

To learn more about Less than (<), check out these useful resources: 

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