id, name shandong01 name1 shandong02 name2 shandong03 name3 beijing01 name4 beijing02 name5 beijing03 name6 shanghai01 name7 复制代码 代码如下:select id,name from table order by case when id like 'shanghai%' then 0 when id like 'b..
有表如下:如何获得如下结果:解法使用xml转换代码如下:复制代码 代码如下:CREATE TABLE body (ID int,BODY nvarchar(20) ) go INSERT INTO body VALUES(1,'aaaa') INSERT INTO body VALUES(2,'bbbb') INSERT INTO body VALUES(1,'cccccc') INSERT..