Can anyone explain the difference in these two functions? Why use one vs' the other?
I found this article on APPROX_COUNT_DISTINCT:
Hope that helps. It looks to be a performance issue when dealing with very large data sets.
This appears to be a SQL function. I'm looking for info on a beastmode function.
I may have mistated the syntax, should be: