select
a.*
from
(
select
row_number()over(partition
by
id
order
by
排序字段)
as
num,*
from
[
table
] )a
where
num<=3
看看就懂了
select
a.*
from
(
select
row_number()over(partition
by
id
order
by
排序字段)
as
num,*
from
[
table
] )a
where
num<=3
看看就懂了