sql查询字段的首字符,反复字符只显示一个

sql查询字段的首字符,重复字符只显示一个select distinct substr(mm.name,0,1) as fnamefrom t_mobile_mod

sql查询字段的首字符,重复字符只显示一个
select distinct substr(mm.name,0,1) as fname  from t_mobile_model mm  where mm.bid = 1 order by fname