Home -> Usenet -> comp.databases.oracle -> I need SQL to make a TOP10 - but how?

I need SQL to make a TOP10 - but how?

From: Thomas Rokamp <crax_at_mail.com>
Date: Tue, 28 Aug 2001 15:24:03 +0200
Message-ID: <3b8b9b73$0$1604$edfadb0f_at_dspool01.news.tele.dk> 






Hi!



I want to make a TOP10 with just a single SQL call. No stored procedures.
Just pure sql.


But how is that done in ORACLE?


In MS Access the function is TOP.


In MySQL there is a LIMIT function...



In Oracle there is...?



Regards - Thomas Rokamp
Received on Tue Aug 28 2001 - 15:24:03 CEST












Original text of this message