How do I amend my query to select specific row numbers?

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

How do I amend my query to select specific row numbers?

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Server Products] >> SQL Server >> How do I amend my query to select specific row numbers?

Page: [1]

Message

<< Older Topic Newer Topic >>

How do I amend my query to select specific row numbers? - 6/18/2008 10:14:38 AM

rtimson261

Posts: 34
Score: 0
Joined: 5/26/2004
Status: offline

Hi,

I have the following query and wish to amend it to be able to specify which rows I want to select from it. the reason for this is to be able to split the output into manageable chunks for an Excel workshhet to handle it. So in essence I want to be able to say select row 1-70000 then change the query to return rows 70001 - 140000. The query I am starting with is.

select    o2.Name0 AS 'Machine Name',
   o1.Name0 AS 'User ID',
   o1.ScreenSaverActive0,
   o1.ScreenSaverExecutable0,
   o1.ScreenSaverSecure0,
   ScreenSaverTimeout0

from v_gs_desktop o1

left outer join v_r_system o2 on
   o1.resourceID = o2.resourceID
Order by o2.Name0

Hope someone can hepl as this has been driving me nuts for hours now. I have trawled the web and all I have found I have not been able to adapt to this query.

Thanks

Rob