Going back or forward 1 record

Dev Shed Forums Sponsor:

July 12th, 2004, 07:11 AM

Contributing User

Join Date: Apr 2004

Posts: 162

Time spent in forums: 3 h 47 m 14 sec
Reputation Power: 5

Going back or forward 1 record

Does anyone know how to go back 1 record?

I know how to go forward 1 record:

Code:

SELECT TOP 1 *
FROM MyTable
WHERE [id] > 27
ORDER BY [id]

This will select the record with the id 28, if id 28 does not exist, then it will select the next available id.

however, then I try:

Code:

SELECT TOP 1 *
FROM MyTable
WHERE [id] < 27
ORDER BY [id]

It goes to the very first record in the table, becuase it selecting the TOP 1 record, How do I only go back 1 record, eg. id 26.

July 12th, 2004, 07:23 AM

Contributing User

Join Date: Jan 2003

Location: Paris Uppland

Posts: 1,784

Time spent in forums: 2 Weeks 4 Days 21 h 42 m 49 sec
Reputation Power: 37

Code:

SELECT TOP 1 *
FROM MyTable
WHERE id < 27
ORDER BY id desc

July 12th, 2004, 08:15 AM

Contributing User

Join Date: Apr 2004

Posts: 162

Time spent in forums: 3 h 47 m 14 sec
Reputation Power: 5

I never see the obvious. Thanks a lot

Viewing: Dev Shed Forums > Databases > MS SQL Development > Going back or forward 1 record

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Forum Jump