Oracle update, order by, oracleorder

Oracle update, order by, oracleorder

Today, I encountered a problem about converting SQL statements into Oracle statements, which is described as follows:

Select * from emp orderby deptno;

Select * from dept;

SQL Server:

Update dept a set dname = (select top 1 ename from emp where deptno = a. deptno orderby sal)

After trying to find the information, the following conversion result is obtained. I don't know if this is feasible:

Update dept a set dname =

(With t as (select ename, deptno from emp orderby sal)

Select ename from t where deptno = a. deptno andrownum = 1)

Whereexists (with t as (select ename, deptno from emp orderby sal)

Selectnullfrom t where deptno = a. deptno)

Execution result:

Select * from dept;

Other alternative methods will be followed.