find out the third highest salary?
Answer Posted / prithvi
select Max(sal) from emp
This will give us 1highest sal
Select Max (sal) from where sal <(select Max(sal) from emp)
Select Max (sal) from where sal <(Select Max (sal) from
where sal <(select Max(sal) from emp))
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the use of show option in imp command.
How can I see all tables in oracle?
How to open and close an explicit cursor in oracle?
What is PL/SQL ?
Where do you use decode and case statements?
What is SQL Tuning Advisor in Oracle?
How to get a list of all user accounts in the database?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What is rowid and rownum in oracle?
Can the query output be sorted by multiple columns in oracle?
What is analyze command used for?
What is literal?
what is port in oracle? how is it related to database application.
How to invoke the original export import utilities?
What is an oracle database table?