使用grouping sets 列出 country_id、line_id、mmc_sale_type_3、customer_type、is_pop、mid_type 所有组合
以下是所有可能的组合:
- country_id
- country_id, line_id
- country_id, line_id, mmc_sale_type_3
- country_id, line_id, mmc_sale_type_3, customer_type
- country_id, line_id, mmc_sale_type_3, customer_type, is_pop
- country_id, line_id, mmc_sale_type_3, customer_type, is_pop, mid_type
- country_id, line_id, mmc_sale_type_3, customer_type, mid_type
- country_id, line_id, mmc_sale_type_3, is_pop
- country_id, line_id, mmc_sale_type_3, is_pop, mid_type
- country_id, line_id, mmc_sale_type_3, mid_type
- country_id, line_id, customer_type
- country_id, line_id, customer_type, is_pop
- country_id, line_id, customer_type, is_pop, mid_type
- country_id, line_id, customer_type, mid_type
- country_id, line_id, is_pop
- country_id, line_id, is_pop, mid_type
- country_id, line_id, mid_type
- country_id, mmc_sale_type_3
- country_id, mmc_sale_type_3, customer_type
- country_id, mmc_sale_type_3, customer_type, is_pop
- country_id, mmc_sale_type_3, customer_type, is_pop, mid_type
- country_id, mmc_sale_type_3, customer_type, mid_type
- country_id, mmc_sale_type_3, is_pop
- country_id, mmc_sale_type_3, is_pop, mid_type
- country_id, mmc_sale_type_3, mid_type
- country_id, customer_type
- country_id, customer_type, is_pop
- country_id, customer_type, is_pop, mid_type
- country_id, customer_type, mid_type
- country_id, is_pop
- country_id, is_pop, mid_type
- country_id, mid_type
- line_id
- line_id, mmc_sale_type_3
- line_id, mmc_sale_type_3, customer_type
- line_id, mmc_sale_type_3, customer_type, is_pop
- line_id, mmc_sale_type_3, customer_type, is_pop, mid_type
- line_id, mmc_sale_type_3, customer_type, mid_type
- line_id, mmc_sale_type_3, is_pop
- line_id, mmc_sale_type_3, is_pop, mid_type
- line_id, mmc_sale_type_3, mid_type
- line_id, customer_type
- line_id, customer_type, is_pop
- line_id, customer_type, is_pop, mid_type
- line_id, customer_type, mid_type
- line_id, is_pop
- line_id, is_pop, mid_type
- line_id, mid_type
- mmc_sale_type_3
- mmc_sale_type_3, customer_type
- mmc_sale_type_3, customer_type, is_pop
- mmc_sale_type_3, customer_type, is_pop, mid_type
- mmc_sale_type_3, customer_type, mid_type
- mmc_sale_type_3, is_pop
- mmc_sale_type_3, is_pop, mid_type
- mmc_sale_type_3, mid_type
- customer_type
- customer_type, is_pop
- customer_type, is_pop, mid_type
- customer_type, mid_type
- is_pop
- is_pop, mid_type
- mid_type
原文地址: https://www.cveoy.top/t/topic/nuW5 著作权归作者所有。请勿转载和采集!