2
Reply

how to use subquery?

HARDIK BHAVSAR

HARDIK BHAVSAR

Nov 25 2013 1:43 AM
848
How to use subquery when return a multiple values in main query?

Example :

select  ProductID from purchaseorderitemdetail where productid in
(select top 5 ProductID,SUM(Amount) from PurchaseOrderItemDetail group by ProductID order by SUM(amount) desc)


Thanking You
Hardik Bhavsar


Answers (2)