怎么排序不来???BUG?
select * from emp where rowid in(
select id from (select rowid id,row_number() over(partition by cla order by grade asc) mingci from emp)
where mingci<4
)
最初由 neilkooo 发布
[B]select * from (select *,row_number() over(partition by cla order by grade asc) mingci from emp)
where mingci<4
--下面是排序
order by cla,grade desc
你这样不行么? [/B]
不行-.-