34,593
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM(
select row_number() over (partition by 日期,账号 order by 信息) as num, * from TEST
)B where num<3
sql2000
select * from (
select (select count(1) from TEST where 日期=t.日期 and 账号=t.账号 and 信息<=t.信息 ) as num ,t.* from TEST t
) B where num<3