Re: How to limit rows read to 1 rows

[Charles Wilt <charles.wilt@xxxxxxxxx>]

LIMIT is non-Standard...

Try FETCH FIRST ROW ONLY

note: alternate syntax
FETCH FIRST 1 ROW ONLY
FETCH FIRST 10 ROWS ONLY



On Fri, Jan 7, 2011 at 12:36 PM, 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.