Re: how can i select top 100 with a sql statement in oracle

From: michael ngong <mngong_at_yahoo.com>
Date: 19 Feb 2002 09:06:14 -0800
Message-ID: <ecf365d5.0202190906.4933e780_at_posting.google.com>

sohelcsc_at_yahoo.com (Leader) wrote in message news:<b1a93c73.0202182341.41a56f2d_at_posting.google.com>...
> Hi all,
> I need a sql statement which will select top 100 or whatever from table.
> please reply me asap
>
>
> thanks
> hoque

select field_name from table_name order by field_name desc

where rownum < 101
Just like the answer to the other question some one asked you? Michael Ngong (Sr DBA) Received on Tue Feb 19 2002 - 18:06:14 CET

This message: [ Message body ]
Next message: Tom McClelland: "Re: This is how U can find out the 'N'th maximum value from a table by sql"
Previous message: DL: "Re: how can i select top 100 with a sql statement in oracle"
In reply to Leader: "how can i select top 100 with a sql statement in oracle"

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

Original text of this message