Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sql question - distinct
David Portas wrote:
> The same reason you are permitted to use parentheses around any scalar
> expression:
>
> SELECT DISTINCT (a), (b), (a+b), (a+b+c)
> FROM tbl;
David,
Thanks for clearing my doubt.
I was confused, thinking about distinct(columnname) in the way of a
function syntax (parameters within parenthesis).
Received on Wed Nov 29 2006 - 23:43:57 CST