select distinct substr(mm.name,0,1) as fname from t_mobile_model mm where mm.bid = 1 order by fname
详细解决方案
sql查询字段的首字符，反复字符只显示一个
热度：97 发布时间：2016-05-05 13:41:25.0
select distinct substr(mm.name,0,1) as fname from t_mobile_model mm where mm.bid = 1 order by fname
相关解决方案