Re: Limiting returned data from SQL Select Satement

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1998/02/21
Message-ID: <34ef3c6d.2260827@www.sigov.si>#1/1

On Thu, 19 Feb 1998 16:02:48 -0700, "Darryl Petruska" <dkpetrus_at_data-insight.com> wrote:

>If you want the top ten values from a list ordered by field 'X' then perform
>the following query:
>
>select *
>from (select * from table_name order by x)
>where ROWNUM <= 10

This wont work! You can't use ORDER BY in a view - and you are using in-line view in your FROM clause.

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Sat Feb 21 1998 - 00:00:00 CST