how to find the second highest salary from emp table?
Answer Posted / hitesh pundir
select max(salary)from m1 where salary <>(select max(salary)
from m1)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How long will it take to learn pl sql?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
How does stored procedure reduce network traffic?
What is the non-clustered index in sql?
Mention what plvcmt and plvrb does in pl/sql?
What is substitution variable?
Will truncate release space?
Enlist the data types that can be used in pl/sql?
How to start oracle sql developer?
Is left join same as inner join?
What are the key differences between SQL and PL SQL?
What is trigger and how to use it in sql?
what are the advantages a stored procedure? : Sql dba
Explain the insert into statements in sql?
how to present a past time in hours, minutes and seconds? : Sql dba