Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 120155 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / prem chhappesh
select max(salary) from emoplyee where salary not in(select max(salary) from employee)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I view tables in sql developer?
How does sql*loader handles newline characters in a record? : aql loader
What is sorting in sql?
how do you know if your mysql server is alive? : Sql dba
How to handle bulk data?
What are the different schemas objects that can be created using pl/sql?
What is meant by user defined function?
What is sap sql anywhere?
Is it possible to sort a column using a column alias?
What is join view in sql?
Why do we use partitions in sql?
What is sql server and ase?
Is crud a cuss word?
How to convert comma separated string to array in pl/sql?
Why functions are used in sql?
