Interested to Buy Any Domain ? << Click Here >> for more details...
how to select second mauximum value in a given table under salary column
- 6 Answers
- 9527 Views
- Sapient, I also Faced
- E-Mail Answers
Answer Posted / jai
SELECT MAX(SALARY) FROM EMPLOYEE
WHERE SALARY NOT IN(SELECT MAX(SALARY) FROM EMPLOYEE)
| Is This Answer Correct ? | 27 Yes | 2 No |
Post New Answer View All Answers
How would you best determine why your MVIEW couldnt FAST REFRESH?
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'));
Can multiple cursors being opened at the same time?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
What is the difference between substr & instr functions?
What is MTTR advisor in Oracle?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
Explain view?
What is a trace file and how is it created in oracle?
How do I uninstall oracle client from windows?
How oracle handles dead locks?
How to rebuild an index in oracle?
How to execute a stored procedure in oracle?
Explain constraining triggers.
candidate key is subset of super key but not vice-verse explain
