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

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

552

Do you know what is sql injection?

537

What are drillthrough reports?

102

Do you know what is openxml in sql server?

610

How to connect a database with sql express.?

560




What is database dimension? : sql server analysis services, ssas

612

Explain triggers?

550

Why use stored procedures in sql server?

552

What does COMMIT command do?

620

Can we use max in where clause?

507

How secure is sql server database?

521

How to generate random numbers with the rand() function in ms sql server?

560

How can you find out which stored procedures are recompiling?

510

How to get a list of columns in a view using the "sp_columns" stored procedure?

610

What is executereader?

541