Quick Links

Select distinct question ... complicated

From:	The Pennant Shop <vicmogroup(at)yahoo(dot)com>
To:	pgsql-hackers(at)postgresql(dot)org
Subject:	Select distinct question ... complicated
Date:	2003-08-06 19:05:47
Message-ID:	20030806190547.91946.qmail@web11501.mail.yahoo.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-hackers

Hi ,

I have a table:
item location
aaa 10
aaa 20
bbb 10
bbb 10
ccc 10
ccc 20

I need to select distinct items where locations are
the same. So result set should look like:
item loation
bbb 10
Already spent 7 hours on this one.

Thanks a lot / Alex

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

	From	Date	Subject
Next Message	John Liu	2003-08-06 19:11:18	Re: Select distinct question ... complicated
Previous Message	Tom Lane	2003-08-06 18:14:25	Re: Passing server_encoding to the client is not future-proof