Return limited rows from a table

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. Received on Thu Nov 30 2006 - 11:25:48 CST