Interested to Buy Any Domain ? << Click Here >> for more details...
how will I find the first 5 highest salaried employees in
each dept in oracle.
- 22 Answers
- 31940 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / md valiyullah
select max(sal)-5 from emp;
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
what are bitmap indexes? How does they work?
What is clustered table in Oracle?
Please explain drop constraint oracle?
What is the difference between PFILE and SPFILE in Oracle?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
what is Single Byte Overhead...?
How to start instance with a minimal initialization parameter file?
What is oracle server autotrace in oracle?
How to invoke the original export import utilities?
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'));
How to define and use table alias names in oracle?
How to unlock the sample user account in oracle?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
Explain an exception?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
