CHAR(DATE( a.DATE ))||' '||REPLACE(CHAR(TIME( a.DATE )),'.',':') AS DATE ------------------------时间格式化
类似group by 分组 和计算分组总数
name.
COUNT(age) OVER (PARTITION BY name) AS age,
COUNT(age) OVER (PARTITION BY '1') AS ages,
CHAR(DATE( a.DATE ))||' '||REPLACE(CHAR(TIME( a.DATE )),'.',':') AS DATE ------------------------时间格式化
类似group by 分组 和计算分组总数
name.
COUNT(age) OVER (PARTITION BY name) AS age,
COUNT(age) OVER (PARTITION BY '1') AS ages,