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

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

Question Posted / ravi148

Answer Posted / ravi148

hi,

dileep is exactly correct , arun .. iam sorry to say ur
wrong

suppose for employee table, write as
DECLARE curTemp SCROLL CURSOR FOR
SELECT TOP 2 * from EMPLOYEE
OPEN curTemp
FETCH LAST FROM curTemp
CLOSE curTemp
DEALLOCATE curTemp

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the options which must be set to allow the usage of optimistic models?

505

List the different types of collation sensitivities in sql server?

520

What are the benefits and tasks of object explorer? : sql server management studio

605

How to create function with parameter in sql server?

549

What is the difference between count and distinct count?

459




Explain the commands in sql server?

540

What is sql server 2000 work load governor?

551

Tell me extended events in sql server 2008?

550

What is coalesce in sql server?

531

How do you drop an index?

495

Is oracle faster than sql server?

549

What is a trigger? Why we need it?

527

How can you list all the table constraints in a database?

501

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

615

How can I check if a view exists in a sql server database?

554