Distinct Values - Mailing list pgsql-sql

From Nicolas
Subject Distinct Values
Date
Msg-id HTaR6.40412$712.4747796@amsnews02.chello.com
Whole thread Raw
Responses Re: Distinct Values
List pgsql-sql
Hi,

I'm trying to retreive DISTINCT Values from a two colomn table called
"Books". The colomns are named "Author" and "URL".
DISTINCT values should be retieved from the "Author" Colomn , and then I
should be able to retrieve the corresponding URL.
How do I build the SQL Query ?
I tried to use: "SELECT DISTINCT Author FROM Books" But this does not allow
me to fetch the URL value on the other colomn.

Thanks
Nicolas




pgsql-sql by date:

Previous
From: "Frank Contrepois"
Date:
Subject: Re: START for SERIAL type?
Next
From: Hans-Jürgen Schönig
Date:
Subject: Re: How to use the template table in postgresql