Re: newbie : writing an efficient query

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? Received on Fri Aug 04 2006 - 17:38:42 CDT