Re: How to limit rows read to 1 rows

[Dennis <iseries@xxxxxxxxxxxx>]

Add FETCH FIRST ROW ONLY to the end of your SELECT statement.

"Darryl Freinkel" <dfreinkel@xxxxxxxxxxxxxxxxx> wrote:

> I have a SELECT statement that returns more than 1 record for a
> invoice. The
> file can have 1 to many invoice records with the same invoice number.
>
>
>
> I need a way to limit the select, to read only one of those invoice
> records.
>
>
>
> There is a solution using LIMIT, but I cannot get that to work.
>
>
>
> Example:
>
>
>
> Select * from table1 T1 where T1.INVOICE in
>
> (Select T2.Invoice from table2 T2 where T1.Invoice = T2.invoice LIMIT
> 1)
>
>
>
> TIA
>
>
>
> Darryl Freinkel
>
>
>
> -- 
> 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.