Re: Real life SQL Brain teaser

if the count is immaterial...why include it?

select distinct type, code
from table

But the OP isn't looking for just the list of distinct type, codes...he
wants a list where the customers with those distinct combinations are
"somehow" included.

The "somehow" isn't very clear to me.

Charles


On Thu, Nov 19, 2020 at 8:17 AM Bob Czopek <bczopek@xxxxxxxxxxxxxxx> wrote:

Real life SQL Brain teaser (Dave)
Your question is how do I get distinct type and code permutations...

Select type, code, count(*)
From table
Group by type, code
Order by type, code;

The count is immaterial, you get all type distinct type, code
combinations...

----------------------------------------------------------------------

message: 1
date: Thu, 19 Nov 2020 14:30:24 +0100
from: Dave <dfx1@xxxxxxxxxxxxxx>
subject: Fwd: Real life SQL Brain teaser

Charles,

That?s amazing but it?s not quite there. If I select the lines where
rownbr = 1, I eliminate the list from customer 3, but I also lose the first
line from customer 2



cust type code ROWNBR

1 T1 C1 1

1 T3 C2 1



2 T1 C1 2

2 T2 C3 1

2 T3 C4 1



3 T1 C1 3

3 T2 C3 2

3 T3 C4 2



Thanks to everyone else for trying whose solution did not work !



End of MIDRANGE-L Digest, Vol 19, Issue 1670
********************************************
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com