Thanks Larry. Your knowledge of SQL*Plus is unparalleled. Thanks also to Stephane
whose algorithm Larry used.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Saturday, September 01, 2001 8:00 AM
To: Multiple recipients of list ORACLE-L
Ia
urse_set(emp_id) course_set
> , emp_id
> from ian
> group by emp_id
> order by 1
> /
>
>
>
>
>
>
> "MacGregor,
> Ian A." To: Multiple recipients of
> list ORACLE-L <[EMAIL PROTECTED]> <
Ian,
Stephane mentioned the possibility of using analytical functions. I know
that you have used the analytical functions in the past so you may have
already taken Stephane's idea and run with it, and maybe Stephane has as
well. If not, here is Stephane's solution modified so that the DB function
<[EMAIL PROTECTED]>
<[EMAIL PROTECTED] cc:
ford.EDU>Subject: RE: An Interesting Grouping
Question | One Solution
Sent by:
"MacGregor,
Ian A." To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
<[EMAIL PROTECTED] cc:
I could not think of a way to do it with any of the analytical functions. The
developer's method was to make an array with
one element being the emplid and the other a string with all that employees courses
sorted and concatenated together. Then one can group the employees by comparing the
"MacGregor, Ian A." wrote:
>
> Given the following Table
>
> emplid course_id
> -- -
> 1 1
> 2 2
> 2 3
> 3 3
> 3 4
>
That's correct.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, August 30, 2001 12:54 PM
To: Multiple recipients of list ORACLE-L
Ian;
Are you saying that if employees 1 and 2 took course 1,2,and 3 but
employee 3 only took cours
Ian;
Are you saying that if employees 1 and 2 took course 1,2,and 3 but
employee 3 only took course 1 and 2 then you would want to see 2 groups:
group 1: Employees 1 and 2 (took courses 1, 2, and 3)
Group 2: Employee 3 (took course 1, and 2)
Kevin
-Original Message-
Sent: Thursday, A