query

[beginner]

table a have two column
deptno, empno
10,100
10,101
10,102
10,103
20,201
20,202
20,204
20,404
30,111
30,112

can i have one query return me
10,"100 101 102 103"
20,"201 202 204 404"
30,"111 112"

[pando]

check pivot queries

[sambavan]

Questions of this nature would be more appropriate under developer forums, than in the admin forum. So I'm moving it to the developer forum.

Sam