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

It's a very small change in 8.1.5.
Get the ORDER BY into an in-line view,
then put the rownum outside the view.

8.1.5 features:
ORDER BY is legal in view definitions and CTAS

select * from
(
SELECT *
FROM T_PEOPLE P, T_STAFF S
WHERE PID = S.ID
ORDER BY P.LASTNAME
)
where rownum < 100

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Pablo Picasso wrote in message <37777f03.284226956_at_enews.newsguy.com>...
>Version is 8.1.5
>
Received on Mon Jun 28 1999 - 10:00:15 CDT