Re: Limiting the resultset returned from a SELECT to the first N rows?

From: miguel <jmiguel_at_cet.pt>
Date: 1997/10/28
Message-ID: <01bce38e$4aa1a520$0a0a2c0a@jmiguel.cet.pt>#1/1

Michael G. Schneider <mgs_software_at_compuserve.com> wrote in article <01bce36a$2a60d980$0201dede_at_mum>...
> I would like to write a SELECT statement and limit the number of returned
> rows. Something like
>
> SELECT * FROM tbl ORDER BY amount TOP 10
>
> Is this possible?
>
> Michael G. Schneider
>
> mgs_software_at_compuserve.com
>

SELECT * FROM tbl ORDER BY amount WHERE ROWNUM<10 Received on Tue Oct 28 1997 - 00:00:00 CST

This message: [ Message body ]
Next message: Gerard H. Pille: "Re: Limiting the resultset returned from a SELECT to the first N rows?"
Previous message: Michael G. Schneider: "Limiting the resultset returned from a SELECT to the first N rows?"
In reply to: Michael G. Schneider: "Limiting the resultset returned from a SELECT to the first N rows?"
Next in thread: Gerard H. Pille: "Re: Limiting the resultset returned from a SELECT to the first N rows?"
Reply: Gerard H. Pille: "Re: Limiting the resultset returned from a SELECT to the first N rows?"
Reply: Michael G. Schneider: "Re: Limiting the resultset returned from a SELECT to the first N rows?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US