34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT COUNT(DISTINCT paihao)*COUNT(DISTINCT pici) r
FROM (
SELECT TOP 2 *
FROM table1
ORDER BY shijian DESC
) t1
select COUNT(1)
from (select top 1 paihao,pici from tb order by shijian) a
where a.paihao=@paihao and a.pici=@pici