any all sql

1
2  SELECT column_name(s)
3
4  FROM table_name
5
6  WHERE 
7  column_name operator ANY
8  (SELECT column_name
9  FROM table_name
10  WHERE
11  condition); 

1
2  SELECT ProductName
3FROM Products
4WHERE ProductID = ANY
5  (SELECT ProductID
6  FROM OrderDetails
7  WHERE Quantity = 10); 

1
2  SELECT ProductName
3FROM Products
4WHERE ProductID = ALL
5  (SELECT ProductID
6  FROM OrderDetails
7  WHERE Quantity = 10);