Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: top N with respect to day and other field
DA Morgan wrote:
> Consider using GROUP BY.
Well but how should I use group by if I have two or more attributes in something like hierarchical order (date, then lup_dir) and I don't want to aggregate the data from the base table any further, but I want to select some tuples out of them just as they are (and ignore the others).
I am a little bit unsure which group-by-aggregate functions you would suggest/use here.
I thought about FIRST but in fact I don't think that the first row returned by dense rank will be quite useful to me...
Regards,
N.
Received on Thu Aug 09 2007 - 17:28:52 CDT
![]() |
![]() |