SQL query to get the following result

vinit_infy · New User Joined: 07 Apr 2005 Posts: 56

I have a table having the below coloumns -

col1 col2
--------------------------------------------
A D
B H
B F
B G

I would like if someone can help me to write a sql query which can return the following output -

A D
B H, F, G

Can someone pls help me out in this?

Thanks a ton in advance.

Craq Giegerich · Posted: Thu Dec 18, 2008 11:08 pm

Would there ever be more then three repetitions being returned?

vinit_infy · New User Joined: 07 Apr 2005 Posts: 56

No, Craq.

Maximum is 3 for distinct values of col2 for a particular col1.

Thanks for your time.

sriraj1122 · New User Joined: 18 Dec 2008 Posts: 15 Location: Hyderabad

I didnt get your result....

Could you xplain one more time ....!!!!!