Skip to Main Content

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!

Top 10 most frequently occurring entries per column

2786694Oct 29 2019 — edited Oct 29 2019

Hello together

I have a master data table. For this I need the 10 most frequent values of each column.

With the function stats_mode I get the most frequent entry. But I need the Top10.

Can anyone help me how to solve this?

Many greetings

Ben

Comments
Post Details
Added on Oct 29 2019
3 comments
1,787 views