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

[Chris Payne <CPayne@xxxxxxxxxxxxxxx>]

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.