how to retrive only second row from table in sql server
2000?
Answer Posted / madhuparna
select top 1 * from (select top 2 * from employee)A
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is inner join? Explain with an example?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
List the advantages of using stored procedures?
Explain the purpose of indexes?
What is a fill factor?
What happens if null values are involved in datetime operations?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
List the different types of collation sensitivities in sql server?
What are dml triggers and types of dml triggers?
Explain different types of Normalization.
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Difference between connected and disconnected database in .net with sql server?
What is provisioning, billing and metering, and connection routing concepts in the service layer?