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 is a proxy class?

1106

What is a system tablespace and when it is created?

1015

How to delete all rows a table in oracle?

1119

Can objects of the same schema reside in different tablespace?

1103

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1931

What is proxy method?

1022

what is normalisation?what are its uses?

2328

List the types of joins used in writing subqueries?

1037

How to import one table back from a dump file?

1085

11. Display the client number and name and the client number and name of the person who referred that client.

2390

How to connect asp pages to oracle servers?

1120

Can we create trigger on materialized view in oracle?

1044

What are the oracle built-in data types?

1134

How to get maxsal , minsal, ename department wise in single query

1603

Explain integrity constraint?

1209