how to find the second highest salary from emp table?
Answer Posted / debasish
select ename,sal from (select ename,sal,row_number()
over(order by sal desc)rn from emp)
where rn=1;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between union and union all command?
What does trigger mean in psychology?
What do you mean by table in sql?
What is sharding in sql?
What is nvl?
Why are indexes and views important to an organization?
Why left join is used in sql?
What are sql functions? Describe the different types of sql functions?
What is the purpose of using pl/sql?
What is information schema in sql?
What are all the ddl commands?
What is java sql package?
What is the maximum number of columns in sql table?
What is assignment operator in pl sql?
What is implicit cursor in pl sql?