Skip to Main Content
Forums

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!

Limit the number of rows per group

727204Oct 10 2009 — edited Oct 10 2009
Hi guys,

I would like to use a query that returns only an n number of rows per group, and still show all the collumns of a table.

For example:

We have a table_customer, I would like to retrieve a 100 records per dealer in one sql


What would be the best way to do this? It doesnt realy matter which records I retrive, the first 100 or random etc.

thanks in advance
This post has been answered by Centinul on Oct 10 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 7 2009
Added on Oct 10 2009
4 comments
3,990 views