How to Select second Maximum salary in a Table ?
Answer Posted / 9896012055
select * salary from table < select max(salary) from table
order by salary;
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What happens to the indexes if a table is recovered?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
In the oracle version 9.3.0.5.0, what does each number shows?
What are the uses of a database trigger?
How to create a single index for multiple columns?
What is control file used for?
Whats the benefit of dbms_stats over analyze?
Can group functions be used in the order by clause in oracle?
How to select an oracle system id (sid)?
Explain oracle’s server parameter file.
What is the difference between hot backup and cold backup in oracle?
Why use resource manager in Oracle?
Can group functions be mixed with non-group selection fields?
Explain mutating triggers.
Does oracle charge for java?