snort snort - move along the line please;-)
-----Original Message-----
From: Palmer Simon
[mailto:oracledba-ezmlmshield-x36267038.[Email address protected]
Sent: 07 January 2008 14:50
To: LazyDBA Discussion
Subject: RE: ORACLE Row Numbers
And thats not something to be sniffed at.
-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x31950046.[Email address protected]
Sent: 07 January 2008 14:44
To: LazyDBA Discussion
Subject: RE: ORACLE Row Numbers
Well, well, well!
It's Michael Peel! Hehe. Oh my! Phew! Hehe. Outstanding! Hehe.
"One COKE" for you! Hehe.
-----Original Message-----
From: Michael Peel
[mailto:oracledba-ezmlmshield-x12802285.[Email address protected]
Sent: Monday, January 07, 2008 9:40 AM
To: LazyDBA Discussion
Subject: RE: ORACLE Row Numbers
Even simpler
SELECT *
FROM (SELECT rownum row_num, b.*
FROM emp b
) A
WHERE A.row_num between 2 and 4
M.
-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x11510395.[Email address protected]
Sent: 07 January 2008 14:22
To: LazyDBA Discussion
Subject: ORACLE Row Numbers
SELECT *
FROM (SELECT rownum row_num, A.*
FROM (SELECT *
FROM emp
) A
) B
WHERE B.row_num between 2 and 4
/
Please take a few minutes to provide feedback on the quality of service
you
received from our staff. The Department of Education values your
feedback as
a customer. Commissioner of Education Dr. Eric J. Smith is committed to
continuously assessing and improving the level and quality of services
provided to you.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]
---------------------------------------------------------------------
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
**********************************************************************
This e-mail is confidential and may be privileged.
It may only be read, copied and used by the intended recipient.
If you have received it in error please contact the sender immediately
by return e-mail. Please then delete the e-mail and any copies of it
and do not use or disclose its contents to any person.
**********************************************************************
Registered Office: Farncombe House, Broadway, Worcestershire, WR12 7LJ
AccuRead Limited Registered Number: 3076187 England
GSL UK Limited Registered Number: 3333860 England
Global Solutions Limited Registered Number: 3189802 England
**********************************************************************
---------------------------------------------------------------------
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
**********************************************************************
APAK Group Limited, Registered in England No. 01451033.
Registered office APAK House, Badminton Court, Station Road, Yate, Bristol, BS37 5HZ.
The information contained in this message or any of its attachments may
be privileged and confidential and intended for the exclusive use of the
addressee. The views expressed may not be APAK policy but the personal
views of the originator. If you have received this message in error, please
advise the sender immediately by reply e-mail and delete this message and
any attachments without retaining a copy. This footnote also confirms that
this email message has been swept for the presence of known computer
viruses before being sent.
**********************************************************************
Oracle LazyDBA home page