how to retrive only second row from table in sql server
2000?
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
Other than truncate statement, which other command can by-pass the trigger on the tables?
What are sql server functions?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
What are key, name and value columns of an attribute? : sql server analysis services, ssas
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What is the maximum length of an alert name?
What is the difference between left and right outer join?
What happens if the update subquery returns multiple rows in ms sql server?
What is a system database and what is a user database?
What is data source in connection string?
Explain tablesample?
What does Master database contains?
What are the filtered indexes?
what is normalization? : Sql server database administration
What is indexing in sql server with example?