Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Differences between Oracle RDBMS and MS SQL Server
In article <061220001352053483%dischner_at_klch.med.uni-muenchen.de>,
dischner_at_klch.med.uni-muenchen.de said...
> Hi,
>
> > - AFAIK, Oracle has no equivalent to SQL server's "top n" in select clause
> > (rownum comparisons don't count)
>
> What's wron with 'select * from big_query where rownum <= 100;' ?
It doesn't give the desired results when using an Order By. How do you get the bottom n records in Oracle?
> > - Oracle doesn't support "x=y" column aliasing ("y as x" is harder
> > to read, IMO)
>
> So use 'select bla_ggg_name name, bla_ggg_dfgdfg shortname from my_table' ;-)
That's the way I have always done it because it is compatible with both. Received on Wed Dec 06 2000 - 08:35:57 CST