Oracle数据库中怎么写可以先安销量降序在取前十条的数据
elect * from (select * from a order by 销量desc ) where rownum<10
select * from (
select
......
order by 销量 desc
)
where rownum<=10
select * from pc.rpt_tool_perf_sx WHERE rownum<=10 order by EQPID DESC
你按照对应的改字段就好了
1min目标场景问卷
立即参与
