Hi
break on deptno;
select deptno,empno,ename,sal from emp order by deptno;

The above sql query will suppress the deptno duplicate value. Is it possible to write a query and get the same result with out using break on deptno?