Re: Specifying the maximum number of rows retrieved from a query?

From: Lun Wing San (Oracle) <wslun_at_qrcsun.qrc.org>
Date: 1997/01/31
Message-ID: <32F2E33A.2B2D@qrcsun.qrc.org>#1/1

Judy Lam wrote:
>
> Is there a way specify the number of rows retrieved from a query?
>
> I have a table that stores article information. I want to retrieve the
> two latest articles.

You can use ROWNUM to control the number of rows retrieved.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

Received on Fri Jan 31 1997 - 00:00:00 CST

This message: [ Message body ]
Next message: Gus Spier: "Landscape printing"
Previous message: Al Chase: "Re: Specifying the maximum number of rows retrieved from a query?"
In reply to: Judy Lam: "Specifying the maximum number of rows retrieved from a query?"

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