how to find the second highest salary from emp table?
Answer Posted / sabari
select max(salary ) from emp where salary<(select max
(salary)from emp )
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is partition by in sql?
How do sql databases work?
Why do we need view in sql?
What is difference between cursor and trigger?
What is pivot table in sql?
How delete all data from table in sql?
How many types of literals are available in pl sql?
What is the non-clustered index in sql?
what is the difference between blob and text? : Sql dba
Why is %isopen always false for an implicit cursor?
Difference between table function and pipelined function?
Can we use join in subquery?
What is pl sql block structure?
What are the benefits of pl/sql packages?
How does cross join work?