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
What is the maximum number of triggers that can be applied to a single table?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
How do we represent comments in oracle?
How to select all columns of all rows from a table in oracle?
What happens if you lost a data file?
How to start an oracle instance?
1) Does oracle have any table which contain all the exceptions and it's code internally?
How a database is related to tablespaces?
is there a tool to trace queries, like profiler for sql server?
How to use in conditions in oracle?
Difference between oracle's plus (+) notation and ansi join notation?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
How to convert characters to dates in oracle?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
Respected sir, Please send me technical questions related to oracle apps..