Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
452
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.56 KB | None | 0 0
  1. mysql> select count(distinct `dim_marketing_sources`.`sublevel2` , `dim_marketing_sources`.`sublevel1`, `dim_marketing_sources`.`mkt_channel`) from `dim_marketing_sources` as `dim_marketing_sources`;
  2. +----------------------------------------------------------------------------------------------------------------------------------+
  3. | count(distinct `dim_marketing_sources`.`sublevel2` , `dim_marketing_sources`.`sublevel1`, `dim_marketing_sources`.`mkt_channel`) |
  4. +----------------------------------------------------------------------------------------------------------------------------------+
  5. | 114780 |
  6. +----------------------------------------------------------------------------------------------------------------------------------+
  7. 1 row in set, 1 warning (2.19 sec)
  8.  
  9. mysql> select count(distinct `dim_marketing_sources`.`sublevel2` , `dim_marketing_sources`.`sublevel1`, `dim_marketing_sources`.`mkt_channel`) from `dim_marketing_sources` as `dim_marketing_sources`;
  10. +----------------------------------------------------------------------------------------------------------------------------------+
  11. | count(distinct `dim_marketing_sources`.`sublevel2` , `dim_marketing_sources`.`sublevel1`, `dim_marketing_sources`.`mkt_channel`) |
  12. +----------------------------------------------------------------------------------------------------------------------------------+
  13. | 114780 |
  14. +----------------------------------------------------------------------------------------------------------------------------------+
  15. 1 row in set, 1 warning (31.24 sec)
  16.  
  17. mysql>
  18. mysql> select count(distinct `dim_marketing_sources`.`sublevel2` , `dim_marketing_sources`.`sublevel1`, `dim_marketing_sources`.`mkt_channel`) from `dim_marketing_sources` as `dim_marketing_sources`;
  19. +----------------------------------------------------------------------------------------------------------------------------------+
  20. | count(distinct `dim_marketing_sources`.`sublevel2` , `dim_marketing_sources`.`sublevel1`, `dim_marketing_sources`.`mkt_channel`) |
  21. +----------------------------------------------------------------------------------------------------------------------------------+
  22. | 114780 |
  23. +----------------------------------------------------------------------------------------------------------------------------------+
  24. 1 row in set, 1 warning (2.17 sec)
  25.  
  26. mysql> select count(distinct `dim_marketing_sources`.`sublevel2` , `dim_marketing_sources`.`sublevel1`, `dim_marketing_sources`.`mkt_channel`) from `dim_marketing_sources` as `dim_marketing_sources`;
  27. +----------------------------------------------------------------------------------------------------------------------------------+
  28. | count(distinct `dim_marketing_sources`.`sublevel2` , `dim_marketing_sources`.`sublevel1`, `dim_marketing_sources`.`mkt_channel`) |
  29. +----------------------------------------------------------------------------------------------------------------------------------+
  30. | 114780 |
  31. +----------------------------------------------------------------------------------------------------------------------------------+
  32. 1 row in set, 1 warning (42.56 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement