SQL Query - Mailing list pgsql-general

Hello List member,

Iha a table containing two columns x and y . for single value of x there are multiple values in y e.g

X      Y
------------
1       ABC
2       PQR
3       XYZ
4       LMN
1       LMN
2       XYZ

I want a query that will give me following output

1   ABC:LMN
2   PQR:XYZ
3   XYZ
4   LMN

Any help will be really helpful

Thanks in advance

With Regards
Ashish

---

Why delete messages? Unlimited storage is just a click away.