Hi,
Is there a a way to do a MINUS/EXCEPT like in SQL ?
Objective is to count all users that are having event for something but not for something else.
example :
SELECT DISTINCT LEARNER from ...
WHERE USER_ACTION_FACT_TYPE in ('Bookmark', 'Share', 'Comment', 'Like','ArticleView' )
MINUS
SELECT DISTINCT LEARNER from ...
WHERE USER_ACTION_FACT_TYPE in ('Training Session' )
What about INTERSECT ?
SELECT DISTINCT LEARNER from ...
WHERE USER_ACTION_FACT_TYPE in ('Bookmark', 'Share', 'Comment', 'Like','ArticleView' )
INTERSECT
SELECT DISTINCT LEARNER from ...
WHERE USER_ACTION_FACT_TYPE in ('Training Session' )
Best regards
Jean-Christophe
Best answer by Joseph Heun
View original