一
一方素笺丶
V1
2022/02/16阅读:30主题:雁栖湖
SQL
// FileName: HelloWorld.java
public class HelloWorld {
// Java 入口程序,程序从此入口
public static void main(String[] args) {
System.out.println("Hello,World!"); // 向控制台打印一条语句
}
}
支持以下语言种类:
bash
clojure,cpp,cs,css
dart,dockerfile, diff
erlang
go,gradle,groovy
haskell
java,javascript,json,julia
kotlin
lisp,lua
makefile,markdown,matlab
objectivec
perl,php,python
r,ruby,rust
scala,shell,sql,swift
tex,typescript
verilog,vhdl
xml
yaml
diff 效果:
SELECT
I20201129083495.dept_cd,
I20201129083495.date,
sum( I20201129083495.Metric + I20201129092381.MetricI20210421021424.waterI20210421021424.waterI20210421021424.waterI20210421021424.water ) AS val
FROM
( SELECT dept_cd AS dept_cd, date AS date, sum( Metric ) AS Metric FROM test_dim GROUP BY dept_cd, date ) I20201129083495,(
SELECT
fire AS dept_cd,
wood AS date,
sum( water ) AS water
FROM
wuxingzt
GROUP BY
fire,
wood
) I20210421021424,(
SELECT
dept_cd AS dept_cd,
date AS date,
sum( Metric ) AS Metric
FROM
test_dim
GROUP BY
dept_cd,
date
) I20201129092381
WHERE
I20201129083495.dept_cd = I20201129083495.dept_cd
AND I20201129083495.dept_cd = I20210421021424.dept_cd
AND I20201129083495.dept_cd = I20201129092381.dept_cd
AND I20201129083495.date = I20201129083495.date
AND I20201129083495.date = I20210421021424.date
AND I20201129083495.date = I20201129092381.date
GROUP BY
I20201129083495.dept_cd,
I20201129083495.date
作者介绍
一
一方素笺丶
V1