table是这样的
seg_name category revenue
INFREQUENT Accessoires 15
INFREQUENT Accessoires 2
INFREQUENT Make up 9
INFREQUENT Make up 33
INFREQUENT Man 8
INFREQUENT Man 94
INFREQUENT Women 32
INFREQUENT Women 23
Loyal Accessoires 72
Loyal Accessoires 13
Loyal Make up 18
Loyal Make up 62
Loyal Man 24
Loyal Man 87
Loyal Women 92
Loyal Women 32
Loyal sun 33
Loyal sun 42
New Accessoires 13
New Accessoires 25
New Make up 45
New Make up 42
New Man 14
New Man 52
New Women 32
New Women 23
New sun 54
New sun 31
我想要一个查询,这样我就可以得到这样的表
seg_name category revenue
INFREQUENT Accessoires 17
INFREQUENT Make up 42
INFREQUENT Man 102
INFREQUENT Women 55
Loyal Accessoires 85
Loyal Make up 80
Loyal Man 111
Loyal Women 124
Loyal sun 75
New Accessoires 38
New Make up 87
New Man 66
New Women 55
New sun 85
在那之后想要最大的收入类别在所有的seg\u名称
seg_name category revenue
INFREQUENT Man 102
Loyal Women 124
New Make up 87
2条答案
按热度按时间bvk5enib1#
ue公司
group by
具有窗口功能:rkttyhzu2#
与
MAX()
以及FIRST_VALUE()
窗口功能:请看演示。
结果: