练习手

CONCAT(a.id, ':', a.id_name) as id_name_str Format(a.weight, 2) as weight_str date_format(a.date,'%Y%m%d')>=date_format(#{beginDate},'%Y%m%d') ifnull(sum(a.sum),0) as totall_sum

ifnull(a.xxx,'') as xxx,     ifnull(Format(a.xxx, 0),'') as xxx_str,

查询列        SELECT aaFROM data_aa查询所有    SELECT * FROM data_aa查询去重    SELECT DISTINCT aaFROM data_aa查询where    SELECT * FROM data_aa WHERE custom_aa='0001'AND & OR 运算符条件都成立    AND条件部分成立    OR一起使用时需...