id type r1 r2 r3
1 1 ab b c
2 2 d d d
3 2 d d d
4 3 d d d
5 4 d d d
6 2 d d d
7 1 b c d
8 1 d d d
9 3 d d d ------------------'
--想要结果
id type r1 r2 r3
1 1 ab b c
2 1 b c d
4 2 d d d
5 2 d d d
6 3 d d d
7 3 d d d
8 4 d d d就是每个 type 取2条值.
1 1 ab b c
2 2 d d d
3 2 d d d
4 3 d d d
5 4 d d d
6 2 d d d
7 1 b c d
8 1 d d d
9 3 d d d ------------------'
--想要结果
id type r1 r2 r3
1 1 ab b c
2 1 b c d
4 2 d d d
5 2 d d d
6 3 d d d
7 3 d d d
8 4 d d d就是每个 type 取2条值.
if object_id('a7') is not null
drop table a7
go
create table a7
(
id int,
type int
)go
insert into a7
select 1,1 union all
select 2,1 union all
select 3,1 union allselect 4,2 union all
select 5,2 union all
select 6,2 union all
select 7,3select * from a7select * from
(
select row_number() over(partition by type order by id ) sid,*from a7
)x where sid <=2