Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 116060 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / hasnain hameed
select max(salary)
from emp
where salary < (select max(salary) from emp)
order by salary desc;
i think this is correct answer all of above because it take
less time to execute. retrive the answer quickly.
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What does count (*) mean?
What is compound trigger?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What is synonyms?
Explain dml and ddl?
Why indexing is needed?
How to check if a column is nullable before setting to nullable?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What is cross join sql?
Is like operator in sql case sensitive?
Write a sql query to convert all character to uppercase after hypen.
How do I edit a trigger in sql developer?
What is a common use of group by in sql?
What is snowflake sql?
How many times can we commit in a loop?
