Depends on the context, but this could work for you......
I want to get the first 50 rows....
select top 50 * from scott.emp (SQL)
select * from emp where rownum < 50 (oracle)
greg
-----Original Message-----
From: Ray O' Brien [mailto:[Email Address Removed] Friday, November 30, 2001 7:00 AM
To: LazyDBA.com Discussion
Subject: Slightly OT - SQL Svr Equivalent of Rownum.
Folks,
Does anyone know the SQL Svr equivalent of Oracle's rownum?
Cheers,
Ray.
************************************************************************
************************************************************************
****************************************************
IMPORTANT NOTICE
This communication contains information which is confidential and may
also be privileged. It is for the exclusive use of the intended
recipient(s). If you are not the intended recipient(s) please note that
any form of distribution, copying or use of this communication or the
information contained within is strictly prohibited and may be unlawful.
Any views or opinions presented are solely those of the sender and do
not necessarily represent those of Qualtrace Solutions.
If you have received this e-mail or any file or attachment transmitted
with it in error please notify:
Customer Care Department at Qualtrace Solutions, Business and Technology
Park, Model Farm Road, Cork, Ireland. Ph: 353-21-4817000;
e-mail:[Email Address Removed] <mailto:e-mail:[Email Address Removed]
Then delete this e-mail from your system.
************************************************************************
************************************************************************
****************************************************
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page