Retrieving Second Row Of Resultset

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Retrieving Second Row Of Resultset

Author

Topic

mark1110
Starting Member

4 Posts

Posted - 2005-03-18 : 18:36:39

Using a stored procecure that uses DB2 SQL, if I create a temporary table that is created from this select statement:

SELECT *
FROM myAddressBook

If the resultset I get back is 20 rows and I want to see just the second or third row, how would I do that?

Thanks,

Mark

PW
Yak Posting Veteran

95 Posts

Posted - 2005-03-18 : 18:44:31

SELECT BOTTOM 1 *
FROM (
SELECT TOP 2 *
) dt

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-03-18 : 18:45:17

Not sure if this'll work in DB2, but here goes anyway.

SELECT TOP 1 *
FROM (SELECT TOP 2 * FROM myAddressBook ORDER BY SomeOrderingColumn ASC) t
ORDER BY SomeOrderingColumn DESC

Here's an example:



DECLARE @myAddressBook table (Column1 int, Column2 varchar(10))

INSERT INTO @myAddressBook VALUES(1, 'Tara')
INSERT INTO @myAddressBook VALUES(2, 'Mike')
INSERT INTO @myAddressBook VALUES(3, 'Alex')
INSERT INTO @myAddressBook VALUES(4, 'Rebecca')
INSERT INTO @myAddressBook VALUES(5, 'Zach')

SELECT TOP 1 *
FROM 
(
	SELECT TOP 2 * 
	FROM @myAddressBook 
	ORDER BY Column1 ASC
) t
ORDER BY Column1 DESC

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources