Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-00907 : missing right parenthesis
Hi.
First of all there is no table alias named t2.
Second. You should first make a select with order by clause, then build on
it a new query and get the rownum = 1
I think it should help.
-- Regards BagietaReceived on Tue Nov 23 2004 - 09:20:02 CST
~~~~~~~~~~~~~~~~~~~~~~~~~~~
dbDeveloper - multiple databases editor http://www.prominentus.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~
![]() |
![]() |