can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 27847 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
What is star, snowflake and star flake schema? : sql server analysis services, ssas
Explain the disadvantages of cursors?
What is the stored procedure?
What does select 1 mean?
When to use Inner join & when to use subquery?
What do you mean by subquery?
How to write a query with a left outer join in ms sql server?
How to set the current database in ms sql server?
Which tools are available to manage SQL Azure databases and servers?
How to create a new login name in ms sql server?
What functions can a view be used to performed?
What is store procedure? How do they work? When do you use?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
What is the purpose of forms?
what is the primary use of the model database? : Sql server administration
