Does Top-N even work in Oracle? That looks like SQL Server syntax to me.

-----Original Message-----
From: Parrot H. Yobera
[mailto:oracledba-ezmlmshield-x13435668.[Email address protected]
Sent: Tuesday, November 28, 2006 7:32 AM
To: LazyDBA Discussion
Subject: RE: need a query or procedure..

If you have a column on which you can sort then I propose Top-N.

-----Original Message-----
From: David NGUYEN
[mailto:oracledba-ezmlmshield-x93988314.[Email address protected]
Sent: Tuesday, November 28, 2006 15:54
To: LazyDBA Discussion
Subject: need a query or procedure..

hello experts,

i have a table tab1(col1,col2) , i just need to get the first 1000 rows

in this table , how to write this query ou procedure.?

thanks in advance.

david..


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





Oracle LazyDBA home page