Re: Return limited rows from a table

hdmiranda_at_gmail.com wrote:
> Hi
> I am using Oracle 9i on Solaris.
> I have a table as such:
>
> col1 col2 col3 col 4 value
> a b c x 1
> a b c y 2
> a b c x 3
> a b c g 4
> d e f l 6
> d e f m 3
> d e f s 7
> d e f j 9
>
> I need to return only 3 three rows for each key (col1, col2, col3) as
> such:
> col1 col2 col3 col 4 value
> a b c x 1
> a b c y 2
> a b c x 3
> d e f l 6
> d e f m 3
> d e f s 7
>
> Any suggestions appreciated.
>
> Thank you.

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/functions001.htm#sthref965

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org