how to retrive only second row from table in sql server
2000?
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
How can I check if a view exists in a sql server database?
what is denormalization and when would you go for it? : Sql server database administration
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
What are joins in sql and what are the different types of joins?
What is the current limitation of the size of SQL Azure DB?
Explain the truncate command? : SQL Server Architecture
Can you create a logon trigger in sql server 2005 express edition?
whats new about truncate in sql server 2008?
How do you delete duplicate records in sql server?
What are horizontal and vertical scaling?
What is global temp table?
Tell me what is the order in which the sql query is executed?
Explain the difference between control flow and data flow?
What are the commands used in DCL?
What is the difference between for trigger and after trigger?