select distinct deptno, max(sal)over ( partition by deptno order by deptno)

i want department wise maxmum salary and empolyee name

Question Posted / sanjaya

Answer Posted / sanjaya

select distinct deptno, max(sal)over ( partition by deptno order by deptno) from emp;

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain about your project and its relation to the current job position you are applying to?

1016

various types of hints and their usage

2704

How do I spool in oracle?

1016

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2122

How to connect to oracle using service name instead of sid?

1028

Explain overloading. Can functions be overloaded?

1005

What are the restrictions in a oracle read only transaction?

1040

What is varray?

1146

Is a rollback possible to any savepoint?

1104

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2018

What is format trigger?

2077

what is the difference between restoring and recovering?

1017

Which are the five query types available in oracle?

958

What is PL/SQL ?

2082

What is object data modeling?

970