Quick Search:
 The Oracle ANY Keyword      [Return To Index] Jump to:  

Term: ANY

The ANY keyword specifies that the search condition will be TRUE if the comparison is TRUE for at least one of the values that is returned. If not, or if no value is returned, the search condition is FALSE.

The following conditions are TRUE when the total price is greater than the total price of at least one of the items in order number 1000. The first condition uses the ANY keyword; the second uses the MIN aggregate function:

total_price > ANY (SELECT total_price FROM sales
WHERE order_number = 1000)

total_price > (SELECT MIN(total_price) FROM sales
WHERE order_number = 1000);
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org