Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: top N with respect to day and other field

Re: top N with respect to day and other field

From: Nikolas Tautenhahn <virtual_at_gmx.de>
Date: Fri, 10 Aug 2007 00:28:52 +0200
Message-ID: <f9g4f2$jc2$00$1@news.t-online.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US