使用订单后如何挑选？(how to pick out after using order by? [duplicate])

使用订单后如何挑选？(how to pick out after using order by? [duplicate])

这个问题在这里已有答案：

ROWNUM如何在分页查询中工作？ 3个答案

我跑：

select aname, APERCENT from AGENTS order by APERCENT DESC;

我得到了这个结果：

ANAME APERCENT john 7 jane 6 teddy 6 bob 6 allen 5 airon 5

现在我想拿起第一列，所以我添加了rownum=1 。

select aname, APERCENT from AGENTS order by APERCENT DESC where ROWNUM=1;

但SQL命令没有正确结束，我想修复它。 我该怎么办？

This question already has an answer here:

How ROWNUM works in pagination query? 3 answers

I run:

select aname, APERCENT from AGENTS order by APERCENT DESC;

and I get this result:

ANAME APERCENT john 7 jane 6 teddy 6 bob 6 allen 5 airon 5

Now I want to pick up first column so I add rownum=1.

select aname, APERCENT from AGENTS order by APERCENT DESC where ROWNUM=1;

But SQL command not properly ended, and I want to fix it. What should I do?

最满意答案

您应该在订购后添加rownum = 1。 所以它会

select * from ( select aname, APERCENT from AGENTS order by APERCENT DESC ) where ROWNUM=1;

You should add rownum=1 AFTER ordering. So it will be

select * from ( select aname, APERCENT from AGENTS order by APERCENT DESC ) where ROWNUM=1;