Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102872 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / sandip
SELECT MAX(SAL) FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);
I don't think this will work correct me if i am
wrong.Correct one is-------
SELECT MAX(SAL) as SAL FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which software is used for pl sql programming?
What is character functions?
Explain the the update statement in sql?
What is the use of desc in sql?
Why is partition used in sql?
Can we use joins in subquery?
what is the difference between clustered and non clustered index in sql? : Sql dba
Can I learn sql in a week?
Can we insert data into materialized view?
What is the advantage of nosql?
What is pl sql block in dbms?
How do you write a subquery?
What is package in pl sql?
State some properties of relational databases?
Explain the commit statement.
