find out the third highest salary?
Answer Posted / harikrishna ravipati
select max(sal) from emp where sal <
(select max(sal) from emp where sal <
(select max(sal) from emp))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
When do I need to use a semicolon vs a slash in oracle sql?
What is a tns service name?
What is archive log in Oracle?
How to invoke the data pump import utility?
What is truncate oracle?
Can I create users through internet explorer in oracle 10g?
What is a system tablespace and when it is created?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What is the relation of a user account and a schema in oracle?
Explain the dml?
How different is ms access and oracle?
What is meant by joins?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What is private procedure oracle?
if you ctreate table identity