How to Select second Maximum salary in a Table ?
Answer Posted / ranjini
select max(salary) from employee not exists (select
max(salary)from employee)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to do a full database export?
What is the purpose of save points in oracle database?
How to use "for" statements in oracle?
Can you have more than one content canvas view attached with a window ?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
material view and view disadvantages?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How do you bind variables in oracle?
Explain what are the different type of segments?
How much memory your 10g xe server is using?
What is dual table oracle?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
Is oracle a language?
Does facebook use oracle?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??