can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 25167 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / neeru
I think Daleep answer is not so precise, if you want 3rd or
ny specified answer, this only can only be seems right for
2nd highest salary, else, its not optimise query.I found
Preeti's query more optimistic and accurate.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain what is analysis service repository?
What happens if you delete a table that is used by a view?
explain declarative management framework (dmf) in sql server 2008?
Explain what are various ways to enhance the ssrs report?
Why use stored procedures in sql server?
How to write a query with a left outer join in ms sql server?
Explain what is the use of custom fields in report?
What are the new scripting capabilities of ssms? : sql server management studio
define and explain the differences between clustered and non-clustered indexes.
How to use copy and concatenate commands in SQL?
How to retrieve error messages using odbc_errormsg()?
What are the restrictions applicable while creating views? : SQL Server Architecture
Difference between report and query parameter.
What are rest-style architecture's?
What is database mirroring?
