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 the use of grant option in imp command.

1006

How to write numeric literals in oracle?

1165

How to see the table columns used in an index?

1007

What is difference between cartesian join and cross join?

1073

What is index in Oracle?

1056

Why does oracle 9i treat an empty string as null?

1037

Explain the features of oracle?

1022

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

1051

Why is oracle so popular?

974

What is memory advisor in Oracle?

1061

What is a trace file and how is it created in oracle?

1033

What is the difference between truncate & delete command?

1166

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2099

What is oracle database 10g express edition?

1109

State and explain the different types of data models?

926