find out the third highest salary?
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
What is a synonym? What are its various types?
How to create an oracle database?
How to execute the package in oracle?
How to drop a stored procedure in oracle?
How do I uninstall oracle 11g?
How do we represent comments in oracle?
How can we view last record added to a table?
State the various uses of dbcc command?
Will you be able to store pictures in the database?
How to call a stored function in oracle?
What is a lookup table in oracle?
How to commit the current transaction in oracle?
Can we use bind variables in oracle stored procedure?
What are the differences between char and varchar2 in oracle?
What is the order of defining local variables and sub procedures/functions?