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

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

Question Posted / dileep.t

15 Answers
26555 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

What is data source object?

992

Why is replication required on the sql server?

1052

Â Explain what is sql override for a source taLle in a mapping?

995

how to determine the service pack currently installed on sql server? : Sql server database administration

952

How to handle error or exception in sql?

974

How do I setup a local sql server database?

989

What is the stuff and how does it differ from the replace function?

1113

What is the most common trace flags used with sql server?

1032

Differentiate between SQL and ORACLE joins and write their syntax.

1025

mention different types of relationships in the dbms?

1008

What is cursors?

1169

ow to bring suspect mode datbase online from scratch

1800

Why use identity in sql server?

1086

Mention a few common trace flags used with sql server?

923

can you implement data mining in SSRS?

147