求解

作者: a516478314   发布时间: 2011-12-10

select * from tb  t
where exists(select 1 from tb where id<t.id and WWName = @WWName and (TalkTime>=@UpS and TalkTime<@UpE) group by talkww
)

作者: chuanzhang5687   发布时间: 2011-12-10

作者: a516478314   发布时间: 2011-12-10

select
 * 
from
 tb  t
where
 exists(select 1 from tb where id<t.id and WWName = @WWName and (TalkTime>=@UpS and TalkTime<@UpE) 

作者: fredrickhu   发布时间: 2011-12-10