SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select top 10 percentage

1001096May 17 2013 — edited May 19 2013

Hi,
I want to get the top 10% of salaries in employees table. But I got error:

SQL> select top 10 percent salary
  2  from employees
  3  order by salary desc;

ORA-00923: FROM keyword not found where expected

How can I get the top 10% percent?
Thanks a lot

This post has been answered by Frank Kulash on May 17 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 16 2013

Added on May 17 2013

6 comments

20,221 views