1.how to extract the second highest salary from emp table
having sal as a column which contains the salary of all
employee of an organisation.
- 6 Answers
- 7243 Views
- I also Faced
- E-Mail Answers
Answer Posted / hema
Select sal from emp a where 2=(select count(distinct sal)
from emp b where a.sal <= b.sal)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are the execution control statements?
What is a user account in oracle?
What is oracle latest version?
What is MTTR advisor in Oracle?
What is oracle thin client?
What is key preserved table?
if you ctreate table identity
What is ASM (Automatic Storage Management) in Oracle?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
How to delete an existing row from a table in oracle?
Why should I use oracle database?
How remove data files before opening a database?
How to get maxsal , minsal, ename department wise in single query
Point out the difference between user tables and data dictionary?
How a tablespace is related to data files?
