how to retrive only second row from table in sql server
2000?
- 15 Answers
- 23201 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
Which sql server table is used to hold the stored procedure script?
What do you mean by tablesample?
How can I know what locks are running on which resource?
What are the different types of replication you can set up in sql server?
What is db stored procedure?
How to define the name and server for a new dsn?
What is normalization and its types?
How to enter binary string literals in ms sql server?
Mention the different types of triggers?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
How to create percentile function?
How much memory that we are using in Logshipping Concept?
What is the default schema of your login session in ms sql server?
How to move database physical files in ms sql server?
