Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrive only second row from table in sql server
2000?
- 15 Answers
- 26690 Views
- Cognizant, CTS, I also Faced
- E-Mail Answers
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
Does server sql treat char as a variable-length or fixed-length column?
What is Extended user-defined?
Ways to improve the performance of a SQL Azure Database?
What is an index. What are the types?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
What is Dependency Injection and provide example?
Differentiate between a having clause and a where clause.
What is @@rowcount in sql?
Explain how you can deploy an SSRS report?
Explain how to send email from sql database?
How many types of schemas are there?
What is merge?
Explain query editor regions
Explain database normalization?
What is triggers in ms sql server?
