4.1: SELECT SUM(IP) FROM (SELECT COUNT(*) AS IP FROM TABLE WHERE ID='001' GROUP BY DATE,IP ) AS TEMP_TABLE4.1 以下 CREATE TEMPORARY TABLE TEMP_TABLE SELECT COUNT(*) AS IP FROM TABLE WHERE ID='001' GROUP BY DATE,IP SELECT SUM(IP) FROM TEMP_TABLE DROP TABLE TEMP_TABLE
select date,count(DISTINCT id) from 表名 where date>=10 and date<=140 Group by id,date
select date,count(DISTINCT ip) from 表名 where date>=10 and date<=140 Group by id,date===================== 不好意思,是count(DISTINCT ip),不是count(DISTINCT id)
select count(DISTINCT ip) from 你的表名 where id='001' and (date>=10 and date<=140)
SELECT SUM(IP) FROM (SELECT COUNT(*) AS IP FROM TABLE WHERE ID='001' GROUP BY DATE,IP ) AS TEMP_TABLE4.1 以下
CREATE TEMPORARY TABLE TEMP_TABLE SELECT COUNT(*) AS IP FROM TABLE WHERE ID='001' GROUP BY DATE,IP
SELECT SUM(IP) FROM TEMP_TABLE
DROP TABLE TEMP_TABLE
不好意思,是count(DISTINCT ip),不是count(DISTINCT id)