How to retrieve values in pl/sql, oracle dev

How to retrieve values in pl/sql, oracle dev
0

#1

Hi all,

I need some help with retrieving some data in existing tables. I can rank them by highest values, but how to retrieve say the top 10 or the top 10% or the lowest values (top 5 or top 5%)?

I use oracle sql developer…so it is pl/sql. Many thanks!


#2

Perhaps DENSE_RANK () is what you are looking for.
Syntax and usage at
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions043.htm