RE: need a query or procedure..

Yes, definitely works better than the old way we had to do this, by
counting and subqueries ...

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail
for such purpose.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

"Edwards Ed "
<oracledba-ezmlms
hield-x4143806.x1 To
[Email Address Removed] "LazyDBA Discussion"
.com> <[Email address protected]
cc
11/29/2006 09:32
AM Subject
RE: need a query or procedure..

Ok! Ok! It's my turn! Hehe.

select * from
(select empno, ename, job, mgr, hiredate, sal, comm, deptno,
rank() over (order by rownum asc) ranking
from emp)
where ranking <= 1000
/

Please take a few minutes to provide feedback on the quality of service you
received. The Department of Education values your feedback as a customer.
Commissioner John L. Winn is committed to continuously assessing and
improving the level and quality of services provided to you by Department
staff. Simply use the link below. Thank you in advance for completing the
survey.

http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]

-----Original Message-----
From: Dustin Hayden
[mailto:oracledba-ezmlmshield-x35172397.[Email address protected]
Sent: Wednesday, November 29, 2006 9:16 AM
To: LazyDBA Discussion
Subject: RE: need a query or procedure..

SELECT /*+ FIRST_ROWS(N) */ ....

-----Original Message-----
From: Strelzyk Stephen
[mailto:oracledba-ezmlmshield-x24012264.[Email address protected]
Sent: Wednesday, November 29, 2006 8:53 AM
To: LazyDBA Discussion
Subject: RE: need a query or procedure..

Select col1,col2 from tab1 where rownum <= 1000

-----Original Message-----
From: David NGUYEN
[mailto:oracledba-ezmlmshield-x93988314.[Email address protected]
Sent: Tuesday, November 28, 2006 6:54 AM
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

---------------------------------------------------------------------
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