--照你给的数据应该是把月份作为num，然后名字和年月拼接显示了select cast(right(id, 2) as int) as num, keyword + '（' + cast(id as varchar(10)) + '）' as keyword from 表名 order by 1
