1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / dileep.t

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

can a database be shrunk with users active? : Sql server administration

568

Explain various On-Delete options in a DB table. Which is the default option?

900

Define normalisation?

678

What are subquery and its properties?

578

What is sub-query in sql server?

673




Explain about the command-line tool SQLCMD?

554

What is the purpose of floor function?

541

What is 3nf normalization form?

567

How display code or Text of Stored Procedure using Sql query in Sql Server ?

610

Determine how to use the inserted and deleted pseudo tables?

539

What are the pre-defined functions in the sql server?

520

how you can list all the tables in a database?

526

What is 2nf example?

552

What is the difference between sdf and mdf?

679

How do I determine how many instances of sql server are installed on a computer?

536