select version as 版本 from cbas_eventdata; 所有
select DISTINCT version as 版本 from cbas_eventdata; 去重
select DISTINCT min( version) as 版本 from cbas_eventdata; 取最小
select count(DISTINCT VERSION) as 版本种类总数 FROM cbas_eventdata ; 版本总类总数
select DISTINCT version as 版本 from cbas_eventdata ORDER BY 版本 ; 结果升序
select DISTINCT version as 版本 from cbas_eventdata ORDER BY 版本 DESC ; 结果降序
这列的总数：
SELECT count() from cbas_eventdata where version like ‘%%‘;
SELECT count() from cbas_eventdata where version is not NULL;
SELECT count(DISTINCT version) from cbas_eventdata;
select count(*) FROM cbas_eventdata where clientdate < ‘2017-04-17 ‘; 查询4月17前的个数
sql查询语句
原文：http://blog.51cto.com/12346621/2154658
