Classics Forum

RE: Re: Return top 20 rows

Posted By:
Date:

Have a look in the Guide to SQL Tutorial, on page 3-14, it gives an
example of how to return the top 'n' rows using a correlated subquery.

Regards

Colin Dawson

>Jay,
>
>I am working on Informix 7.3 and your first select statement works:
>
>SELECT FIRST 20 field1, field2
>FROM table
>ORDER BY field1 DESC
>
>Kipp D. Sherry
>IT Systems Analyst
>Idaho Department of Correction
>Administration Office / IT
>Phone: 208-658-2089
>Fax: 208-327-7469
>
>>>> "Jay " <jay2@iafalls.com> 05/12/03 01:55PM >>>
>I am on Informix 7.2
>
>I am trying to do a query that returns the top2 amounts paid. I can't =
>figure out how to do it on 7.2
>
>I have tried
>
>select first 20 field1, field2
>from table
>order by field1 desc
>
>select field1, field2
>from
>(select field1, field2 from table
>order by field1 desc)
>where rowid < 21
>
>But each time I get a syntax error. Is there another way to do this? I
=
>don't think TOP is a keyword either.
>
>Thanks in advance.
>
>
>



--=_b52d208603095e50758d910104368224--

Messages In This Thread

• Return top 20 rows
  Jay -- Monday, 12 May 2003, at 3:55 p.m.
  • Re: Return top 20 rows
    Kipp Sherry -- Monday, 12 May 2003, at 6:10 p.m.
    • RE: Re: Return top 20 rows
      Colin Dawson -- Tuesday, 13 May 2003, at 3:56 a.m.
    • Re: Return top 20 rows
      Ana Paola Amadeo -- Tuesday, 13 May 2003, at 9:37 a.m.
      • Re: Return top 20 rows
        Sushil Birla -- Tuesday, 13 May 2003, at 10:48 a.m.
        • RE: Return top 20 rows
          Buenaposada Cano, Oscar -- Tuesday, 24 June 2003, at 3:42 a.m.
  • RE: Return top 20 rows
    shahid.mehmood -- Wednesday, 14 May 2003, at 12:26 a.m.

Classics Forum is maintained by Administrator with WebBBS 5.12.