select *
from (select emp.*,row_number() over(partition by deptno order by rownum) cn from emp)
where cn = 1;
转载于:https://www.cnblogs.com/zyhblogs/p/4466010.html
select *
from (select emp.*,row_number() over(partition by deptno order by rownum) cn from emp)
where cn = 1;
转载于:https://www.cnblogs.com/zyhblogs/p/4466010.html