How to select N no. of row for each group

#1

Deptno Dname
------ -----
10 ACCOUNTS
20 SALES
30 MARKETING
40 RESEARCH

i want a query which will select lets say first 5 employees for each deptno.

Thanks

#2

use COUNT() along with GROUP BY
sorry I was not able to give an example
"Mir" <mhyder (AT) rice (DOT) edu> wrote

Quote:

Deptno Dname
------ -----
10 ACCOUNTS
20 SALES
30 MARKETING
40 RESEARCH

i want a query which will select lets say first 5 employees for each
deptno.

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to select N no. of row for each group

comp.database.oracle comp.database.oracle

How to select N no. of row for each group - 05-18-2004 , 02:15 PM

Re: How to select N no. of row for each group - 05-28-2004 , 02:01 PM