The SQL Less Than Or Equal To 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 by using <.
Here are a couple of examples:
|5 <= 20||TRUE|
|10 <= 10||TRUE|
SELECT ProductNumber, Name, ListPrice FROM Production.Product WHERE ListPrice <= 100 ORDER BY ListPrice Desc
SQL Less Than or Equal To with Other Types
Here we’re returning products modified before February 15th, 2014.
SELECT ProductNumber, Name, ListPrice, ModifiedDate FROM Production.Product WHERE ModifiedDate <= '2014-02-15'
To learn more about SQL Less than (<), check out these useful resources: