Interested to Buy Any Domain ? << Click Here >> for more details...
can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 32034 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 the difference between the application object and session object?
What is the Control Flow in SSIS
How to download and install sql server 2005 books online?
Mention the differences between having and where clause.
How to perform backup for certificates in sql server? : sql server security
What is sql server database?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
What are the advantages of passing name-value pairs as parameters?
Does sql server use java?
What is server-level principal?
Explain what are the authentication modes in sql server?
Can you always create a cache of a report?
what are database files and filegroups? : Sql server database administration
explain different types of joins? : Sql server database administration
What is the syntax for encrypting a column in SQL Server?
