Re: get distinct values

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Fri, 12 Mar 2010 15:42:24 -0800 (PST)
Message-ID: <42d09cd5-2587-40d8-83da-d6b4f21afa8c_at_j27g2000yqn.googlegroups.com>

On Mar 12, 4:58 pm, webtourist <webtour..._at_gmail.com> wrote:

snip

> How can I get result like this: (distinct names in "job_list") ?
>
> DEPTNO JOB_LIST
> ------ ----------------------------------------------------
>     10 CLERK MANAGER PRESIDENT
>     20 ANALYST CLERK MANAGER
>     30 CLERK MANAGER SALESMAN
Are you running 7.3.4? Received on Fri Mar 12 2010 - 17:42:24 CST