select split_part('123,456,789',',',2); ---分割字符串并且取出指定字符串
select distinct [字段名称] from [表名]; ---去重
select left('123456',3); ---从左起取指定个数字符select right('123456789',3); ---从右边起取指定个数字符
order by convert_to([字段名],[编码]) ---汉字排序
更多处理参考:【转载】http://www.cnblogs.com/wuhenke/archive/2010/08/02/1790750.html