---------------------------------- :), This will also work, without additi

how to retrive only second row from table in sql server
2000?

Question Posted / dileep.t

15 Answers
26161 Views
Cognizant, CTS, I also Faced
E-Mail Answers

Answer Posted / dileep.t

----------------------------------
:), This will also work, without additional columns in
result
---------------------------------

DECLARE curTemp SCROLL CURSOR FOR
SELECT TOP 2 * from <TABLE_NAME>
OPEN curTemp
FETCH LAST FROM curTemp
CLOSE curTemp
DEALLOCATE curTemp

Is This Answer Correct ?

12 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain forward - only cursors?

977

When to use null data driven subscription?

196

What are the advantages dts has over bcp?

940

how you can configure a running aggregate in SSRS?

184

What are the different normalization forms?

1046

What is default constraint?

931

What is sharding?

114

What is temporal table?

822

When does a workload on SQL Azure get throttled?

129

what are the different ways to return the rowcount of a table?

942

What is a rownum?

893

What are the types of processing and explain each? : sql server analysis services, ssas

1102

What is the difference between TRUNCATE and DROP?

1063

What are the 3 types of schema?

1041

Explain transaction server auto commit?

987