目录
-
求和sum $符号
-
交叉浮动
纵向浮动
横向浮动
效果
SQL:
SELECT
a.C2,
a.C1,
a.B2,
b.C2,
b.B2,
c.C2,
c.C1
FROM
(
SELECT
sum(a.WJ_9) AS C2,
a.AJFL AS C1,
a.DQ AS B2
FROM
tj_wj a
GROUP BY
a.DQ,
a.AJFL
) a
INNER JOIN (
SELECT
*
FROM
(
SELECT
sum(a.WJ_9) AS C2,
a.DQ AS B2
FROM
tj_wj a
GROUP BY
a.DQ
) AS temp_
LIMIT 1000
) b ON (
a.B2 = b.B2
OR (a.B2 IS NULL AND b.B2 IS NULL)
)
INNER JOIN (
SELECT
*
FROM
(
SELECT
sum(a.WJ_9) AS C2,
a.AJFL AS C1
FROM
tj_wj a
GROUP BY
a.AJFL
) AS temp_
LIMIT 50
) c ON (
a.C1 = c.C1
OR (a.C1 IS NULL AND c.C1 IS NULL)
)
SQL效果:
-
序号 使用# 也可以使用row()
-
排名
表元代号.rank
也可以:_rk()函数:括号中的参数需要写指标名,而不是表元代号
_rk()函数功能更加强大,不仅可以返回排名,还可以对指标进行排序
-
排序
由于是对浮动出来的数据进行排序,故需要在浮动表元属性中进行设置
也可列头排序
-
Top排序
-
一个浮动维内有两个主题表