Re: rownum kills Order... Is there a solution ?

Version is 8.1.5

Is there a possibility do avoid this in this version ?

Thanks for your answer..

On Mon, 28 Jun 1999 14:05:18 +0100, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>
>Which version of Oracle ?
>
>You can achieve the effect by side-effects
>(always risky) in Oracle 7, by using object types
>in Oracle 8.0, and by direct SQL in Oracle 8.1
>
>--
>
>Jonathan Lewis
>Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
>Pablo Picasso wrote in message <3777519d.272604113_at_enews.newsguy.com>...
>>Hi all,
>>
>>I have 2 tables ..
>>t_people and t_staff (linked by id)
>>
>>I want to select it with
>>
>>SELECT * FROM T_PEOPLE P, T_STAFF S WHERE
>>P.ID = S.ID AND ROWNUM < 100 ORDER BY P.LASTNAME;
>>
>>The result is ordered by lastname, but there are gaps in the
>>result, meaning, that result may contain the person with lastnames
>>'Anker','Berlin','Breuer' but the person with lastname 'Barton' is
>>ommitet.
>
>
>
Received on Mon Jun 28 1999 - 08:57:35 CDT