Use the SQL ANY Operator with a subquery to compare one value to any value returned from the subquery.  If one or more values from the SQL subquery satisfy the comparison’s condition, the comparison returns TRUE. 

Unlike the ALL operator, to satisfy ANY, only one value must meet the condition. 

Note:  Keep and mind that SOME and ANY are equivalent.  Wherever we use a SQL ANY operator in our examples, you are free to substitute SOME

ANY Operator Syntax 

Here is the general syntax for ANY: 

SELECT column1, column2, … 
FROM table 1 
WHERE column2 > ANY (subquery1) 

Though we use greater than in our example above (>), when using SQL ANY you can substitute it for any valid comparison operator.  Other examples include: 

Operator Meaning
X = ANYReturn TRUE if X equals ANY result returned from the subquery
X <> ANYReturn TRUE if X does not equal any result returned from the subquery. 
X > AnyReturn TRUE if X is greater than ANY result returned from the subquery. 
X >= ANY Return TRUE if X is greater than or equal to ANY result returned from the subquery.
X < ANY Return TRUE if X is less than ANY result returned from the subquery.
X <= ANY Return TRUE if X is less than or equal to ANY result returned from the subquery. 

SQL Any Operator Example 

Here we are returning every product whose safety stock level is greater than any of the average safety stock levels for products grouped by DaysToManufacture.   

Try it for yourself.

SELECT ProductID, Name, SafetyStockLevel, DaysToManufacture FROM Production.Product WHERE SafetyStockLevel > ANY (SELECT AVG(SafetyStockLevel) FROM Production.Product GROUP BY DaysToManufacture)
SELECT ProductID, 
       Name, 
       SafetyStockLevel, 
       DaysToManufacture 
FROM   Production.Product 
WHERE  SafetyStockLevel > ANY (SELECT   AVG(SafetyStockLevel) 
                               FROM     Production.Product 
                               GROUP BY DaysToManufacture) 

Keep in mind that for the result to return rows, any SafetyStockLevel from Product has to be greater than ANY of the subquery’s Average SafetyStockLevels. 

Other Resources 

To learn more about SQL ANY, 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
>