can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
Answer Posted / harikumar
select max(salary) as secondMax from employee where id <>
(select max(salary) from employee)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What does it mean if @@cursor_row returns a negative number?
Is sql server a database?
What are two difference between sql azure and azure tables?
What the class forname () does?
How to write a query with a full outer join in ms sql server?
What program is used to store the data source file?
What are trace flags and mention a few common trace flags used with sql server?
Do you know what are the steps to process a single select statement?
Tell me the phases a transaction has to undergo?
Explain how does the report manager work in ssrs?
What is oltp (online transaction processing)?
what are constraints? Explain different types of constraints? : Sql server database administration
Relational calculus is what type of language?
What do you understand by triggers and mention the different types of it?
Tell me something about security and sql azure?