select * from (select tbEmp.Ename,tbProd.Ptype,Tbprod.Pmark,Tbprod.Pspec,Tbsales.Pqty,Tbsales.Pamount,
Tbsales.Sdata from tbemp,tbprod,tbsales where tbemp.eid = tbsales.eid and tbsales.pid = tbprod.pid order by tbsales.sdata desc) where rownum <= 10;
oracle查询前10条记录按某个字段降序排列
最新推荐文章于 2024-08-08 07:30:30 发布