ANY is used with three operator-
1)-< ANY-It means less than the max value in the list.
2)-= ANY-It means equal to any value in the list(similar to IN operator).
3)-> ANY-It means greater than the minimum value in the list.
SELECT columnname FROM tablename WHERE columnname operator ANY (SELECT column_name FROM table_name WHERE condition);
SELECT product_name FROM products WHERE product_id = ANY (SELECT product_id FROM orders WHERE quantity= 8);
Coderraj is the global online platform and circle for programmers to learn, communicate, share their knowledge and growth their careers.
Copyright ©2022 coderraj.com. All Rights Reserved.