22,301
社区成员




CREATE TABLE TestTable(
id int,
test varchar(2) )
insert into TestTable(id,test) values( '1','你')
insert into TestTable(id,test) values( 1,'好')
insert into TestTable(id,test) values( 1,'是')
insert into TestTable(id,test) values( 2,'个')
insert into TestTable(id,test) values( 1,'三')
insert into TestTable(id,test) values( 1,'晕')
insert into TestTable(id,test) values( 2,'晕')
insert into TestTable(id,test) values( 2,'色')
insert into TestTable(id,test) values( 3,'不')
insert into TestTable(id,test) values( 3,'不')
insert into TestTable(id,test) values( 3,'不')
insert into TestTable(id,test) values( 3,'不')
insert into TestTable(id,test) values( 3,'不')
insert into TestTable(id,test) values( 3,'不')
insert into TestTable(id,test) values( 3,'不')
insert into TestTable(id,test) values( 3,'不')
SELECT * FROM
(SELECT *,ROW_NUMBER() OVER(PARTITION BY ID ORDER BY test) row
FROM
TestTable)T
WHERE
row <= 5
id test row
1 好 1
1 你 2
1 三 3
1 是 4
1 晕 5
2 个 1
2 色 2
2 晕 3
3 不 1
3 不 2
3 不 3
3 不 4
3 不 5