Selecting A Range of Records (Rows) In SQL Server 2000

--Select record 1 only from the Orders table in the Northwind Database
SELECT TOP 1 *
FROM orders
WHERE orderid NOT IN (SELECT TOP 0 orderID
FROM orders
ORDER BY orderID)
ORDER BY orderID

--Select record 2 only from the Orders table in the Northwind Database
SELECT TOP 1 *
FROM orders
WHERE orderid NOT IN (SELECT TOP 1 orderID
FROM orders
ORDER BY orderID)
ORDER BY orderID

--Select records 11-20 from the Orders table in the Northwind Database
SELECT TOP 10 *
FROM orders
WHERE orderid NOT IN (SELECT TOP 10 orderID
FROM orders
ORDER BY orderID)
ORDER BY orderID

--Select last record only from the Orders table in the Northwind Database
SELECT TOP 1 *
FROM orders
WHERE orderid NOT IN (SELECT TOP 1 orderID
FROM orders
ORDER BY orderID)
ORDER BY orderID DESC

--Select last 3 record only from the Orders table in the Northwind Database
SELECT TOP 3 *
FROM orders
WHERE orderid NOT IN (SELECT TOP 3 orderID
FROM orders
ORDER BY orderID)
ORDER BY orderID DESC



________________________________

From: Tremor Olaes [mailto:mssqldba-ezmlmshield-x78417090.[Email address protected]
Sent: Tue 6/28/2005 5:18 PM
To: LazyDBA Discussion
Subject: Selecting range of rows



I need to select the first 65,000 rows and place it in excel, then I
need to select the rest of the records 65,000 to 93,000. How do I write
the query? I know I can write to grab "TOP 65,000, but how do I grab
the rest?



Tremor Olaes

Business Systems Analyst

Office 1-858-228-2711

Mobile 1-949-842-9171



Success



"To laugh often and much; to win the respect of intelligent people and
the affection of children; to earn the appreciation of honest critics
and endure the betrayal of false friends; to appreciate beauty, to find
the best in others; to leave the world a bit better, whether by a
healthy child, a garden patch or redeemed social condition; to know even
one life has breathed easier because you have lived. This is to have
succeeded."

-Ralph Waldo Emerson





Attention:
Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this in error, please contact the sender and delete the material from any system and destroy any copies.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




MS Sql Server LazyDBA home page