SQL Query

From: Ashish Karalkar <ashish_postgre(at)yahoo(dot)co(dot)in>
To: pgsql-general(at)postgresql(dot)org, ashish(dot)karalkar(at)netcore(dot)co(dot)in
Subject: SQL Query
Date: 2007-12-05 10:24:04
Message-ID: 843803.85383.qm@web94301.mail.in2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2007-12-05 10:35:48 Re: SQL Query
Previous Message Tomas 2007-12-05 10:23:40 Re: pg_dump: could not format inet value