select * from
(
select id as Name , Subject = 'id' , Result = id from tb1
union all
select id as Name , Subject = 'yytc' , Result = yytcfrom tb1
) t
order by name , case Subject when 'id' then 1 when 'yytc' then 2 end
没有数据库,没法给你测试,你用这个试试,看好不好使
如果不好使,可以访问这个地址:
http://blog.csdn.net/vipxiaotian/article/details/4409423里边有行转列,列转行,应该有你想要的,你看看
本回答被提问者和网友采纳