GROUPING_ID

description

Syntax

GROUPING_ID(expr)

GROUP_ID is used to distinguish the grouping statistics results of the same grouping standard.

example

1. MySQL > SELECT COL1,GROUPING_ID(COL2) AS 'GroupingID' FROM tbl GROUP BY ROLLUP (COL1, COL2);
2. +------+------------+
3. | COL1 | GroupingID |
4. +------+------------+
5. | NULL |          1 |
6. | 2.20 |          1 |
7. | 2.20 |          0 |
8. | 1.10 |          1 |
9. | 1.10 |          0 |
10. +------+------------+

keywords

GROUPING_ID