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

define and explain the differences between clustered and non-clustered indexes.

689

Why do we use stored procedures in sql server?

589

What is sql server database?

578

Explain the properties of subqueries in sql server?

626

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

650




What is 1nf normalization form?

679

What is "scheduled jobs" or "scheduled tasks"?

650

Tell me what is log shipping?

669

How do I find the sql server instance name?

620

How to drop an existing stored procedure in ms sql server?

638

What is forward - only cursors / read only cursor?

626

How to handle error or exception in sql?

621

What is the current pricing model of SQL Azure?

96

What is query cost in sql server?

646

How to copy data from one table to another table?

648