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

What are the types of trigger in oracle?

572

Explain rename?

549

What is the best way to do multi-row insert in oracle?

559

What is concurrency in oracle?

540

What is the difference between $oracle_base and $oracle_home?

579

How to check your oracle database 10g xe installation?

577

What is a schema in oracle?

536

What is the quickest way to fetch the data from a table?

564

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

541

Can we store images in oracle database?

545

What are the different types of failures that occur in Oracle database?

594

What is an oracle cursor variable?

607

What is raw datatype in oracle?

581

Is primary key indexed by default in oracle?

540

Is oracle an operator?

528