concatenation of rows

[kranti116]

I have the following table contents:
ID kEYWORD
-------- ----------------------
1 AB
1 AC
1 AD
2 XX
2 YYY


I need to convert this to the following output:

ID kEYWORD
-------- ----------------------
1 AB,AC,AD
2 XX,YYY


How can I do this?
I don't like to use procedures, functions or any anonymous blocks
it should be a simple statement starting with select

[debasisdas]

You need to use DECODE for all that.

[kranti116]

You need to use DECODE for all that.

can u frame the exact query with decode

[amitpatel66]

Please try and post back inc ase of any issues