select t.* from
(select sc_oto_equi.*,row_number() over (partition by group_id order by group_id) rn from sc_oto_equi where comp_code = ‘100011’) t
where rn=N
注:其中N代表要查询的第N条数据
partition:分割、分开、区分、隔开
select t.* from
(select sc_oto_equi.*,row_number() over (partition by group_id order by group_id) rn from sc_oto_equi where comp_code = ‘100011’) t
where rn=N
注:其中N代表要查询的第N条数据
partition:分割、分开、区分、隔开