Top Number of Record in SQL
Posted on 2003-12-05
Is there anyway to select the (Top 10 Records) based on the CountOfSummaryItem in the following SQL?
s_Sql = "SELECT DAuthor, Count(DAuthor) As CountOfSummaryItem, _
(Count(*)/(Select count(*) FROM tbl_Records_DR)) as Percentage _
From tbl_Records_DR GROUP BY DAuthor Order BY DAuthor;"
Thanks guys. ADawn