Its all about structured query language (SQL) - SQL Query Snippets, LINQ Snippets, SQL Stored Procedures, SQL Server Articles, SQL Server Feeds, SQL Server Analytics, SQL Server Integration Services (SSIS), Microsoft SQL Server BIG DATA - HortonWorks, SQL Server CRM Integration
Pages
▼
Wednesday, May 9, 2007
No of Records using Select Query
-- 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
No comments:
Post a Comment