//筛选某一字段为数字且大于0的语句
select * from table WHERE concat('',field*1)=field AND ziduan>0
//去重某一字段查询并返回其它所有字段唯一简便方法
SELECT *,count(distinct field) FROM table group by field
