Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 153801 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / punit chauhan
select * from emp where sal<(select max(sal) from emp
where sal<(select max(sal) from emp))
punit chauhan
iMS NOIDA
doing MCA
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
How many anonymous blocks can be defined?
Where are the settings stored for each instance in oracle?
How to create an oracle testing table?
Why we use bulk collect in oracle?
What is a oracle database?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
How to synchronize 2 schema's objects?
How to export several tables together?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What is the difference between "as" and "is" in an oracle stored procedure?
what is the difference between functional dependecy and multilevel dependency?
What is the use of aggregate functions in oracle?
How to pass a parameter to a cursor in oracle?
Give the different types of rollback segments.
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
