Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary in a given table????
- 5 Answers
- 8696 Views
- I also Faced
- E-Mail Answers
Answer Posted / shahnaz
To find the 2nd highest salary from emp table:
select max(sal) from emp where sal not in (select max(sal)
from emp )
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is PL/SQL ?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What is the Tune Query
How to change program global area (pga) in oracle?
How to connect to oracle using service name instead of sid?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How to create a temporary table in oracle?
What is the difference between sharding and partitioning?
Explain the use of Merge statement in oracle 11g
how to handle exceptions in post production
How to set up autotrace for a user account?
What is meant by joins?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
what is the difference between data migration and production migration.
Explain the use of compress option in exp command.
