Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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`;
- +----------------------------------------------------------------------------------------------------------------------------------+
- | count(distinct `dim_marketing_sources`.`sublevel2` , `dim_marketing_sources`.`sublevel1`, `dim_marketing_sources`.`mkt_channel`) |
- +----------------------------------------------------------------------------------------------------------------------------------+
- | 114780 |
- +----------------------------------------------------------------------------------------------------------------------------------+
- 1 row in set, 1 warning (2.19 sec)
- 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`;
- +----------------------------------------------------------------------------------------------------------------------------------+
- | count(distinct `dim_marketing_sources`.`sublevel2` , `dim_marketing_sources`.`sublevel1`, `dim_marketing_sources`.`mkt_channel`) |
- +----------------------------------------------------------------------------------------------------------------------------------+
- | 114780 |
- +----------------------------------------------------------------------------------------------------------------------------------+
- 1 row in set, 1 warning (31.24 sec)
- mysql>
- 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`;
- +----------------------------------------------------------------------------------------------------------------------------------+
- | count(distinct `dim_marketing_sources`.`sublevel2` , `dim_marketing_sources`.`sublevel1`, `dim_marketing_sources`.`mkt_channel`) |
- +----------------------------------------------------------------------------------------------------------------------------------+
- | 114780 |
- +----------------------------------------------------------------------------------------------------------------------------------+
- 1 row in set, 1 warning (2.17 sec)
- 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`;
- +----------------------------------------------------------------------------------------------------------------------------------+
- | count(distinct `dim_marketing_sources`.`sublevel2` , `dim_marketing_sources`.`sublevel1`, `dim_marketing_sources`.`mkt_channel`) |
- +----------------------------------------------------------------------------------------------------------------------------------+
- | 114780 |
- +----------------------------------------------------------------------------------------------------------------------------------+
- 1 row in set, 1 warning (42.56 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement