Re: newbie : writing an efficient query

dn.perl_at_gmail.com wrote:
> One more point which I have been curious about .
> Why doesn't 'distinct' work on composite fields?
>
> Table t1 : a1 number, a2 number.
> Entries : (1,11) (2,21), (2,22) (2,22) (2,23) (2,23)
> (3,33) (3, 33)
>
> select distinct(a1, a2) from t1 ... does not work.
> How do I write that query?

Remove the parentheses:

select distinct a1, a2 from t1

Documentation: http://snipurl.com/uf81 Received on Fri Aug 04 2006 - 18:28:47 CDT