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: 

10 <=5FALSE
5 <= 20TRUE
10 <= 10TRUE
SELECT ProductNumber, Name, ListPrice FROM Production.Product WHERE ListPrice <= 100 ORDER BY ListPrice Desc
SELECT ProductNumber, Name, ListPrice
FROM   Production.Product
WHERE  ListPrice <= 100
ORDER BY ListPrice Desc

SQL Less Than or Equal To with Other Types 

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

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

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

Additional Resources 

To learn more about SQL Less 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.

__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"b6728":{"name":"Main Accent","parent":-1},"03296":{"name":"Accent Low Opacity","parent":"b6728"}},"gradients":[]},"palettes":[{"name":"Default","value":{"colors":{"b6728":{"val":"var(--tcb-skin-color-0)"},"03296":{"val":"rgba(17, 72, 95, 0.5)","hsl_parent_dependency":{"h":198,"l":0.22,"s":0.7}}},"gradients":[]},"original":{"colors":{"b6728":{"val":"rgb(47, 138, 229)","hsl":{"h":210,"s":0.77,"l":0.54,"a":1}},"03296":{"val":"rgba(47, 138, 229, 0.5)","hsl_parent_dependency":{"h":210,"s":0.77,"l":0.54,"a":0.5}}},"gradients":[]}}]}__CONFIG_colors_palette__
Name*
Email*
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"dffbe":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"dffbe":{"val":"var(--tcb-color-4)"}},"gradients":[]},"original":{"colors":{"dffbe":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45}}},"gradients":[]}}]}__CONFIG_colors_palette__
Sign Up
>