MSSQL - using count

[heather_j92002]

Is it possible to join this query to itself
and then Sum the count of the [Hit] field to display it
within the same query?

Select
Distinct
Count (*) as [Total],
SiteName,
Grade,
(Select distinct Count(*)) as [Hit]
-- Sum(Hit) as [HitTotal]
From
Information
Group by
SiteName,
Grade
Order by
Sitename,
Grade

Total Sitename Grade Hit
165 West 30 1
147 West 31 1
127 West 32 1
113 East 30 1
99 East 31 1

I realize I will see the hit total sum on every record, but that would be ok.

[MAK]

try this
http://www.databasejournal.com/featu...le.php/3373861
http://www.databasejournal.com/featu...0894_3373861_2