how to retrive only second row from table in sql server
2000?
Answer Posted / arun kumar k s
drop table #temp select top 2 identity(int,1,1) as SlNo, *
into #temp from TABLE_NAME select * from #temp where SlNo=2
Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
What is set nocount on and what is set nocount off?
What does the update command do?
What is subquery in sql?
Write a query to find 5th highest amount paid from the customer table.
What is raid, and how it can influence database performance?
Explain Normalization and DE normalization
Can a function call a stored procedure in sql server?
What are date and time data types in ms sql server?
what is the difference between Delete and Truncate command in SQL
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
According to you what goes into making the best database administrator? : sql server database administration
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
What you can do to delete a table without the delete trigger firing?
Explain foreign key in sql server?
Does full backup break log chain?