RE: Is it possible to do a 'Select FIRST x - records' in SQL

[Chris Payne <CPayne@xxxxxxxxxxxxxxx>]

I think that limit might be a proprietary extension, not in the sql standard
(much like "fetch first n rows").

Chris

-----Original Message-----
From: Jeffrey Lee [mailto:jeff@xxxxxxxxxxxxxxxxxxx] 
Sent: Tuesday, August 10, 2004 2:47 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Is it possible to do a 'Select FIRST x - records' in SQL 

I use that in php on linux, I was assuming that sql on the 400 used the same
syntax


----- Original Message ----- 
From: "Chris Payne" <CPayne@xxxxxxxxxxxxxxx>
To: "'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, August 10, 2004 1:21 PM
Subject: RE: Is it possible to do a 'Select FIRST x - records' in SQL


> Jeff what release are you on because I just tried your limit syntax on
v5r1
> and it failed.
>
> Chris
>
> -----Original Message-----
> From: Jeffrey Lee [mailto:jeff@xxxxxxxxxxxxxxxxxxx]
> Sent: Tuesday, August 10, 2004 2:02 PM
> To: RPG programming on the AS400 / iSeries
> Subject: Re: Is it possible to do a 'Select FIRST x - records' in SQL
>
> Or you could use a limit
>
> SELECT * FROM contact LIMIT 5
>
> ----- Original Message ----- 
> From: "Chris Payne" <CPayne@xxxxxxxxxxxxxxx>
> To: "'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx>
> Sent: Tuesday, August 10, 2004 12:48 PM
> Subject: RE: Is it possible to do a 'Select FIRST x - records' in SQL
>
>
> > I can't tell what you are doing with that statement, but if your
question
> is
> > "how do I select first x - records" you can do the following
> >
> > Select foo , bar
> > >From foobar
> > Where
> > Foo = 5 fetch first 10 rows only
> >
> > Chris
> >
> > -----Original Message-----
> > From: Corteville, Thierry [mailto:Thierry.Corteville@xxxxxxxxx]
> > Sent: Tuesday, August 10, 2004 6:29 AM
> > To: 'rpg400-l@xxxxxxxxxxxx'
> > Subject: Is it possible to do a 'Select FIRST x - records' in SQL
> >
> > I'm having a production order file wich contains Po-nbr and a week
> >
> > Po-nbr      : nprod
> >
> > Start-week : dplsw
> >
> > Tool-nbr   : ntool
> >
> >
> >
> >
> >
> > I want to retrieve  only the first PO-nbr to start.... but it is
possible
> to
> > have 2 or more Po's starting the same date... in that case I only want
the
> > first PO-nbr
> >
> >
> >
> > What I did so far ...
> >
> > with whpo (wntool, wdplsw)
> >
> >  as (select ntool, min(dplsw)  from pofile
> >
> >      group by ntool)
> >
> > select nprod, dplsw, ntool, wntool, wdplsw
> >
> > from pofile left outer join whpo
> >
> >    on wntool=ntool and wdplsw=dplsw
> >
> >
> >
> > But the what I want to avoid 'duplicate records... what I would need in
> fact
> > is a select first....
> >
> >
> >
> > Anyone good ideas ?
> >
> >
> >
> >
> >
> > Thierry
> >
> >
> >
> > --
> > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
> > --
> > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
> >
> >
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.