"Andre Grosse" <ag17_at_inf.tu-dresden.de> wrote in message
news:3C451945.4010904_at_inf.tu-dresden.de...
> > And I suspect for your usage that you really don't understand rownum in
> > Oracle either. Be sure you do before you use it. There is no rownum < 1.
> >
>
>
> sure there is no rownum < 1, but i use an automatic mssql to oracle
> translator, i.e. replacing "top n" with "rownum <= n", works for me thus
> far...that there is no rownum = 0 is a known fact, but rownum = 1 or <=
> 1 is equivalent in this case.
No it isn't. see http://www.jlcomp.demon.co.uk/faq/top_sql.html for a
(probably too wordy you just can't trust these authors) explanation.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Wed Jan 16 2002 - 03:49:50 CST
