Please see this..
SELECT DEPARTMENT_ID, EMPLOYEE_ID FROM EMPLOYEES;
Result:
DEPARTMENT_ID EMPLOYEE_ID
10 200
20 201
20 202
30 114
30 115
30 116
30 117
30 118
30 119
40 203
60 103
60 104
60 105
60 106
60 107
70 204
90 100
90 101
90 102
100 108
100 109
100 110
100 111
100 113
100 112
110 205
110 206
I want to see this in the following way..
Result:
DEPARTMENT_ID EMPLOYEE_ID
10 200
20 201, 202
30 114, 115, 116, 117, 118, 119
40 203
60 103, 104, 105, 106, 107
70 204
90 100, 101, 102
100 108, 109, 110, 111, 112, 113
110 205, 206
Please help me to make me the query.