rownum kills Order... Is there a solution ?

From: Pablo Picasso <Pablo.picasso_at_cyberdude.com>
Date: Mon, 28 Jun 1999 10:43:20 GMT
Message-ID: <3777519d.272604113@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.

Is there a contruction , maybe with group by and having or something else to get correct results ?

Any suggestion is welcome..

Thanks in Advance

Please mail to: oengst_at_cybernet-ag.net.mil (Spamprotect..remove .mil) Received on Mon Jun 28 1999 - 05:43:20 CDT