main logo
Subject: RE: [NF] Equivalent of "Select TOP N" in Oracle?
Author: Vince Teachout
Posted: 2004/11/30 21:46:04
 
View Entire Thread
New Search


At 08:05 PM 11/30/04 -0600, pbibro /at/ onlineltc D.O.T com wrote:
>Content-Class: urn:content-classes:message
>Content-Type: text/plain;charset="utf-8"
>
>http://www.petefreitag.com/item/59.cfm

Which says for Oracle:

Oracle

SELECT column FROM table
WHERE ROWNUM <= 10

Perfect! Thanks! And, a keeper of a website to boot, as I also do Mysql
and MSSql as well. Thank you, mysterious pbibro@onlineltc.com with no name!




 
©2004 Vince Teachout
<-- Prior Message New Search Next Message -->