RE: Sql retrieve first 10 rows

[beppecosta <beppecosta@xxxxxxxxxxx>]

Hi,

the last part of the stmt "Where rowNbr <= 10" it is not accepted but if I move the select into a with common table expr and then a run a select on it, I get what I'm looking for (and and can also get rid of the rowNbr column that is not among the original table columns).

Thanks for your suggestion.

Giuseppe.



--- Mar 22/7/08, Wilt, Charles <WiltC@xxxxxxxxxx> ha scritto:

> Da: Wilt, Charles <WiltC@xxxxxxxxxx>
> Oggetto: RE: Sql retrieve first 10 rows
> A: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> Data: Martedì 22 luglio 2008, 13:57
> Yes, if you are on v5r4...
>
> I haven't used the OLAP features, so this may not be
> exactly right but...
>
> Select branchCode, amount, 
>        row_number() over (partition by branchCode) as
> rowNbr
> > From table
> Where rowNbr <= 10
>
>
> HTH,
>
> Charles Wilt 
> --
> Software Engineer
> CINTAS Corporation - IT 92B
> 513.701.1307
>
> wiltc@xxxxxxxxxx
>
>
> > -----Original Message-----
> > From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-
> > bounces@xxxxxxxxxxxx] On Behalf Of beppecosta
> > Sent: Tuesday, July 22, 2008 6:16 AM
> > To: Midrange L
> > Subject: Sql retrieve first 10 rows
> >
> > I have a table that contains 2 fields: branch code and
> amount.
> > Is is possible to exctract the first 10 rows for each
> branch ?
> > Thanks.
> >
> >
> >
> >       Posta, news, sport, oroscopo: tutto in una sola
> pagina.
> > Crea l&#39;home page che piace a te!
> > www.yahoo.it/latuapagina
> > --
> > This is the Midrange Systems Technical Discussion
> (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit:
> http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the
> archives
> > at http://archive.midrange.com/midrange-l.
>
>
>
> This e-mail transmission contains information that is
> intended to be confidential and privileged.  If you receive
> this e-mail and you are not a named addressee you are hereby
> notified that you are not authorized to read, print, retain,
> copy or disseminate this communication without the consent
> of the sender and that doing so is prohibited and may be
> unlawful.  Please reply to the message immediately by
> informing the sender that the message was misdirected. 
> After replying, please delete and otherwise erase it and
> any attachments from your computer system.  Your assistance
> in correcting this error is appreciated.
> -- 
> This is the Midrange Systems Technical Discussion
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.


      Posta, news, sport, oroscopo: tutto in una sola pagina. 
Crea l&#39;home page che piace a te!
www.yahoo.it/latuapagina