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

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 28 Jun 1999 14:05:18 +0100
Message-ID: <930575368.823.2.nnrp-04.9e984b29@news.demon.co.uk>

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:05:18 CDT