multi_row_sub_query_using_all_operator.sql

use techysanoj;

show tables;

select * from ecommerce_sales_large limit 10;

-- all those product_id where quantity is 2
select product_id from ecommerce_sales_large where quantity = 2;

-- want to find those details whose product id is < ALL this
select * from ecommerce_sales_large 
where product_id < ALL (select 
product_id from 
ecommerce_sales_large 
where quantity = 2); -- use of all operator is that we can use < and > 
-- so like all those entries will be shown like from the sub query it return like 3, 5, 7 
-- then the outer query will show entris where the product_id is < 3 and 5 and 7 means till 1,2 but not 3, 5, 7 or others.


-- main difference is that
-- in any operator the OR is used in between multiple row values
-- in all operator the AND is used in between multiple row values