-- No of Total Records using Select Query
Select count(*) from Purchasing.PurchaseOrderDetail
-- No of Records for each group using Select Query
Select PurchaseOrderID, count(*) NoOfRec from Purchasing.PurchaseOrderDetail Group By PurchaseOrderID
Showing posts with label No of Records for each group using Select Query. Show all posts
Showing posts with label No of Records for each group using Select Query. Show all posts
Wednesday, May 9, 2007
Subscribe to:
Posts (Atom)
