tag:blogger.com,1999:blog-495177919198719500.post653253702827146516..comments2023-12-27T20:52:29.483-08:00Comments on Microsoft Sql Server Tutorials: How to List TOP 'N' Rows along with a Count using SQL ServerSuprotim Agarwalhttp://www.blogger.com/profile/08349831623922214390noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-495177919198719500.post-48171371250629047562009-09-02T00:23:42.843-07:002009-09-02T00:23:42.843-07:00SELECT a.CustomerID, a.CompanyName,(Select Count(*...SELECT a.CustomerID, a.CompanyName,(Select Count(*)from <br />(select TOP (5) * from Northwind.dbo.Customers <br />WHERE CustomerID = a.CustomerID AND ContactTitle = 'Owner') as TotalSimilarTitles,COUNT(*)<br />FROM Northwind.dbo.Customers a<br />group by a.CustomerIDsandynoreply@blogger.com