Re: interesting "group by" usage

On Mon, 05 Mar 2001 17:55:27 -0600, Zhiliang Hu <zhu_at_genomicfx.com> wrote:

>
>I have a table that contains jobs done by different people
>at different times and I have a need to see a list of names
>with unique name entries. So I tried a
>
>> select fname, lname from job_done group by fname, lname;
>
>that works! ("not a group by expression" isn't it? ;-)
>-- indeed, when I tried the same thing through a web interface
>(via CGI <-> SQLPLUS) it complains "not a group by expression"
>Any thought why?
>
>Or is there an option that allows return of unique entries?
>(I didn't seem to find one).
>
>Zhiliang
>

select distinct fname, lname from job_done

Hth,

Sybrand Bakker, Oracle DBA Received on Mon Mar 05 2001 - 23:57:58 CST