Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8637 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
Can a formula column be obtained through a select statement ?
What are a query and state the different types of queries and their uses?
What is bind variable in oracle 11g?
How do I connect to oracle?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How to get execution statistics reports on query statements?
Which environment variables are absolutely critical in order to run the OUI?
what is Single Byte Overhead...?
How can we find out the duplicate values in an oracle table?
How to delete all rows a table in oracle?
How can I create database in oracle?
What is oracle used for?
What is open database communication (odbc) in oracle?
What is the difference between formal parameters and actual parameters?
Can we commit inside a function in oracle?
