display the same name once
A single select statement (select distinct employee_id, dept,sal from employee_dept where current_record=1 order by employee_id) returns this output:
EMPLOYEE_ID | DEPT | SAL
-----------------------------
1 x 100
1 y 200
1 z 500
2 x 200
2 z 500
Is there a way that we get the output like this:
EMPLOYEE_ID | DEPT | SAL
-----------------------------
1 x 100
y 200
z 500
2 x 200
z 500
Thank you,