RE: need a query or procedure..

RE: need a query or procedure..

 

  

Why? Hehe.


-----Original Message-----
From: Joel
[mailto:oracledba-ezmlmshield-x59676590.[Email address protected]
Sent: Wednesday, November 29, 2006 12:41 PM
To: LazyDBA Discussion
Subject: RE: need a query or procedure..

Select col1,col2 from tab1 where rownum <= 1000

Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546

-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x13294257.[Email address protected]
Sent: Wednesday, November 29, 2006 11:19 AM
To: LazyDBA Discussion
Subject: RE: need a query or procedure..

Well, well, well!
It's Joel! Hehe. How have you been? I have been waiting for that
question! Hehe. Yes, they are the same! Now, my question to you is:
Which one runs the fastest? Hehe.


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

Did I miss something? Are these three not the same?

Select col1,col2 from tab1 where rownum <= 1000


Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546
select * from
(select empno, ename, job, mgr, hiredate, sal, comm, deptno,
rank() over (order by rownum asc) ranking
from emp)
where ranking <= 1000
/

select rownumber, deptno, empno
from(
select row_number() over(order by deptno) as rownumber, deptno, empno
from emp) t where rownumber <= 10 /






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




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