how to calcuate the second highest salary of he employee
Answer Posted / lalit
select name, sal from (select name,sal from emp where sal<(select max(sal) from emp) order by sal desc)where rownum=1;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the sql commands?
How can you know that statistics should be updated?
what is sql profiler? : Sql dba
what is self join and what is the requirement of self join? : Sql dba
What are the types of sql commands?
Can we rollback after truncate?
What is the default isolation level in sql server? : Transact sql
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
Why is there a need for sqlcode and sqlerrm variables?
What are primary key and foreign key and how they work?
Is sql a oracle?
How many sql are there?
What is cte?
Enlist the characteristics of pl/sql?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba