Re: SQL question

From: Dario <drga59_at_hotmail.com>
Date: 23 Jun 2004 23:39:05 -0700
Message-ID: <e409f463.0406232239.4ad5eec3@posting.google.com>

FlameDance <FlameDance_at_gmx.de> wrote in message news:<cbctag$r8q$01$1_at_news.t-online.com>...
> Hi everyone,
>
> why does one of these very similar statements work and the other doesn't?
>
> SQL> select distinct fa20, '2' from t_2;

Distinct here means distinct rows not distinct fa20 If you look syntax diagram (sql reference manual), distinct must come after select.

hth Received on Thu Jun 24 2004 - 01:39:05 CDT