试试这样
SELECTdt,
uv,
(uv-duv)/luvASrihuanbi
FROM
(
SELECTdt,
uv,
(
SELECTTOP1
uv
FROM
(
SELECTdt,
COUNT(DISTINCTcookie)ASuv
FROMdata
WHEREdt>=date_sub(from_unixtime(unix_timestamp(),'yyyy-MM-dd'),14)
GROUPBYdt
)bb
WHEREdt=date_sub(from_unixtime(unix_timestamp(),'yyyy-MM-dd'),1)
)ASduv
FROM
(
SELECTdt,
COUNT(DISTINCTcookie)ASuv
FROMdata
WHEREdt>=date_sub(from_unixtime(unix_timestamp(),'yyyy-MM-dd'),14)
GROUPBYdt
)b
)t
WHEREdt>=date_sub(from_unixtime(unix_timestamp(),'yyyy-MM-dd'),7);
|