Wed Aug 15, 2018 3:08 pm
Login Register Lost Password? Contact Us


Distinct Count during a table?

Questions around writing code and queries

Mon Nov 27, 2017 11:20 am Change Time Zone

Hi there,

Is there something similar to the SQL distinct count function? Right now I am creating two different tables one with the groupings to get the distinct counts and one that does my regular aggregations then joining on a match key.

Thanks!

Katy
KatyChow
 
Posts: 25
Joined: Mon Jun 02, 2014 3:16 pm

Mon Nov 27, 2017 8:12 pm Change Time Zone

Would DISTRIBUTION work for you?

https://hpccsystems.com/training/docume ... UTION.html

HTH,
Jim
JimD
 
Posts: 132
Joined: Wed May 18, 2011 1:35 pm


Return to Programming

Who is online

Users browsing this forum: No registered users and 1 guest