rollup问题

[yinwun]

select top 10 L.[description],count(description) AS linkTotal,L.KeyPhrase from linktracker L
where L.dateEntered > '11/12/2005' and L.dateEntered < '12/13/2005' and KeyPhrase = 'Student Loan' and KeyPhrase is not null
group by L.[description],KeyPhrase with rollup

description LinkTotal KeyPharese
Email Sent 100 Student Loan
Email Sent 100 NULL
Got Link - 3 way link 200 Student Loan
Got Link - 3 way link 200 NULL
Got Link - free link 300 Student Loan
Got Link - free link 300 NULL

为什么加了rollup就出现一条重复额度记录。我想计算每一个total的总值

[子陌红尘]

select
top 10
L.[description],
count(description) AS linkTotal,
L.KeyPhrase
from
linktracker L
where
L.dateEntered > '11/12/2005'
and
L.dateEntered < '12/13/2005'
and
KeyPhrase = 'Student Loan'
and
KeyPhrase is not null
group by
L.[description],KeyPhrase with rollup
having
grouping(L.[description])=1 or grouping(KeyPhrase)=0