Re: Need Help with PL/SQL

Thomas J. Kyte <tkyte_at_us.oracle.com> wrote in article <326d9737.9779201_at_dcsun4>...
>
> On Wed, 23 Oct 1996 09:56:17 -0400, "Kevin S. DeWitt" <dewitt_at_interramp.com>
> wrote:
>
> >Thomas J. Kyte wrote:
> >> (... SELECT skipped ...)
> >
> >Will your solution work if there is an ORDER BY
> >involved? My understanding of rownum is that it is
> >derived prior to the sort.
>
> Correct, you can't use rownum and order by at the same time. You can use group
> by and rownum together in the above fashion tho. The rownum will be evaluated
> AFTER the group by has taken place.
>
>
> Thomas Kyte
> Oracle Government

As I've thought ROWNUM is proccessed BEFORE "GROUP BY" too, because "WHERE clause", where it use, evaluate first. Correct me if it isn't truth.

-- 
G'luck !
-----------------------------------------
Garry M. Filimonov,
Project Manager & Oracle DBA,
LASU TRINITI, Troitsk, MR, 142092, Russia
garry_at_triniti.troitsk.ru
+7(095)334-0408