Nicolas schrieb:
> 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
I want a "dirty" solution try something like that. If you use "group by
author" url must be in aggregate function. The authors are now DISTINCT.
myjava=# SELECT author, max(url) FROM books group by author;
author | max
+-
abc| dsafsdf
cde| sdfdsf
(2 rows)
Hans
