how to retrive only second row from table in sql server
2000?
Answer Posted / belson gnana pradeep
SELECT TOP 1 salary FROM
(SELECT DISTINCT TOP 2 salary FROM employee
ORDER BY salary DESC) a ORDER BY salary
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to update a field in SQL after ALTERING a row?
Why variables called the most powerful component of ssis?
What are parameterized reports? What are cascading parameters in ssrs reports?
What is collation sensitivity? Explain different types.
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What is the maximum size of column in sql server?
What are different type of Collation Sensitivity?
What is a dataset and what are the different types of datasets?
What’s the use of custom fields in report?
what are the different stages of Report Processing?
What new changes are being made in SQL Server?
What is blocking?
What are transactions and its controls?
explain different types of constraints? : Sql server database administration
how many no of arguments can be passed in procedures and functions