group by, order by and rownum

Here's the scenario:

I have a table with ids, parent_ids, and values. What I want to do is

Group all tuples with the same parent id Order by over the ids
return the 2nd tuple for each group (via Rownum, I think)

After trying to get this to work, I've stumbled and cannot figure out how to go about it. Is it even possible to use rownums and groupbys in that fashion?

thanks.

brian Received on Tue Aug 13 2002 - 13:07:33 CDT