这样的语句在SQLSERVER，应该怎么写？
select '语文优秀',min(语文) from (select top 15 percent 语文 from cj order by 语文 desc)
union all
select '数学',min(数学) from (select top 15 percent 数学 from cj order by 数学 desc)
union all
select '英语',min(英语) from (select top 15 percent 英语 from cj order by 英语 desc)
union all
select '生物',min(生物) from (select top 15 percent 生物 from cj order by 生物 desc)
union all
select '政治',min(政治) from (select top 15 percent 政治 from cj order by 政治 desc)
union all
select '历史',min(历史) from (select top 15 percent 历史 from cj order by 历史 desc)
union all
select '物理',min(物理) from (select top 15 percent 物理 from cj order by 物理 desc)
union all
select '化学',min(化学) from (select top 15 percent 化学 from cj order by 化学 desc)
UNION ALL
select '总分',min(总分) from (select top 15 percent 总分 from cj order by 总分 desc)
union all
select '语文良好分',min(语文) from (select top 40 percent 语文 from cj order by 语文 desc)
union all
select '数学',min(数学) from (select top 40 percent 数学 from cj order by 数学 desc)
union all
select '英语',min(英语) from (select top 40 percent 英语 from cj order by 英语 desc)
union all
select '生物',min(生物) from (select top 40 percent 生物 from cj order by 生物 desc)
union all
select '政治',min(政治) from (select top 40 percent 政治 from cj order by 政治 desc)
union all
select '历史',min(历史) from (select top 40 percent 历史 from cj order by 历史 desc)
union all
select '物理',min(物理) from (select top 40 percent 物理 from cj order by 物理 desc)
union all
select '化学',min(化学) from (select top 40 percent 化学 from cj order by 化学 desc)
UNION ALL
select '总分',min(总分) from (select top 40 percent 总分 from cj order by 总分 desc)
union all
select '语文及格分',min(语文) from (select top 60 percent 语文 from cj order by 语文 desc)
union all
select '数学',min(数学) from (select top 60 percent 数学 from cj order by 数学 desc)
union all
select '英语',min(英语) from (select top 60 percent 英语 from cj order by 英语 desc)
union all
select '生物',min(生物) from (select top 60 percent 生物 from cj order by 生物 desc)
union all
select '政治',min(政治) from (select top 60 percent 政治 from cj order by 政治 desc)
union all
select '历史',min(历史) from (select top 60 percent 历史 from cj order by 历史 desc)

union all
select '物理',min(物理) from (select top 60 percent 物理 from cj order by 物理 desc)
union all
select '化学',min(化学) from (select top 60 percent 化学 from cj order by 化学 desc)
UNION ALL select '总分',min(总分) from (select top 60 percent 总分 from cj order by 总分 desc);

以上代码在ACCESS中，可以正常查询。在sqlserver中，应该怎么修改呢？

[最优解释]

SELECT  '语文优秀' [状态],
         MIN(语文)[学科]
 FROM    ( SELECT TOP 15 PERCENT
                     语文
           FROM      cj
           ORDER BY  语文 DESC
         )a
 UNION ALL
 SELECT  '数学' ,
         MIN(数学)
 FROM    ( SELECT TOP 15 PERCENT
                     数学
           FROM      cj
           ORDER BY  数学 DESC
         )b
 UNION ALL
 SELECT  '英语' ,
         MIN(英语)
 FROM    ( SELECT TOP 15 PERCENT
                     英语
           FROM      cj
           ORDER BY  英语 DESC
         )c
 UNION ALL
 SELECT  '生物' ,
         MIN(生物)
 FROM    ( SELECT TOP 15 PERCENT
                     生物
           FROM      cj
           ORDER BY  生物 DESC
         )d
 UNION ALL
 SELECT  '政治' ,
         MIN(政治)
 FROM    ( SELECT TOP 15 PERCENT
                     政治
           FROM      cj
           ORDER BY  政治 DESC
         )e
 UNION ALL
 SELECT  '历史' ,
         MIN(历史)
 FROM    ( SELECT TOP 15 PERCENT 
 
                     历史
           FROM      cj
           ORDER BY  历史 DESC
         )f
 UNION ALL
 SELECT  '物理' ,
         MIN(物理)
 FROM    ( SELECT TOP 15 PERCENT
                     物理
           FROM      cj
           ORDER BY  物理 DESC
         )g
 UNION ALL
 SELECT  '化学' ,
         MIN(化学)
 FROM    ( SELECT TOP 15 PERCENT
                     化学
           FROM      cj
           ORDER BY  化学 DESC
         )h
 UNION ALL
 SELECT  '总分' ,
         MIN(总分)
 FROM    ( SELECT TOP 15 PERCENT
                     总分
           FROM      cj
           ORDER BY  总分 DESC
         )j
 UNION ALL
 SELECT  '语文良好分' ,
         MIN(语文)
 FROM    ( SELECT TOP 40 PERCENT
                     语文
           FROM      cj
           ORDER BY  语文 DESC
         )k
 UNION ALL
 SELECT  '数学' ,
         MIN(数学)
 FROM    ( SELECT TOP 40 PERCENT
                     数学
           FROM      cj
           ORDER BY  数学 DESC
         )l
 UNION ALL
 SELECT  '英语' ,
         MIN(英语)
 FROM    ( SELECT TOP 40 PERCENT
                     英语
           FROM      cj 
 
           ORDER BY  英语 DESC
         )m
 UNION ALL
 SELECT  '生物' ,
         MIN(生物)
 FROM    ( SELECT TOP 40 PERCENT
                     生物
           FROM      cj
           ORDER BY  生物 DESC
         )n
 UNION ALL
 SELECT  '政治' ,
         MIN(政治)
 FROM    ( SELECT TOP 40 PERCENT
                     政治
           FROM      cj
           ORDER BY  政治 DESC
         )o
 UNION ALL
 SELECT  '历史' ,
         MIN(历史)
 FROM    ( SELECT TOP 40 PERCENT
                     历史
           FROM      cj
           ORDER BY  历史 DESC
         )p
 UNION ALL
 SELECT  '物理' ,
         MIN(物理)
 FROM    ( SELECT TOP 40 PERCENT
                     物理
           FROM      cj
           ORDER BY  物理 DESC
         )q
 UNION ALL
 SELECT  '化学' ,
         MIN(化学)
 FROM    ( SELECT TOP 40 PERCENT
                     化学
           FROM      cj
           ORDER BY  化学 DESC
         )r
 UNION ALL
 SELECT  '总分' ,
         MIN(总分)
 FROM    ( SELECT TOP 40 PERCENT
                     总分
           FROM      cj
           ORDER BY  总分 DESC
         )s
 UNION ALL
 SELECT  '语文及格分' , 
 
         MIN(语文)
 FROM    ( SELECT TOP 60 PERCENT
                     语文
           FROM      cj
           ORDER BY  语文 DESC
         )t
 UNION ALL
 SELECT  '数学' ,
         MIN(数学)
 FROM    ( SELECT TOP 60 PERCENT
                     数学
           FROM      cj
           ORDER BY  数学 DESC
         )u
 UNION ALL
 SELECT  '英语' ,
         MIN(英语)
 FROM    ( SELECT TOP 60 PERCENT
                     英语
           FROM      cj
           ORDER BY  英语 DESC
         )v
 UNION ALL
 SELECT  '生物' ,
         MIN(生物)
 FROM    ( SELECT TOP 60 PERCENT
                     生物
           FROM      cj
           ORDER BY  生物 DESC
         )w
 UNION ALL
 SELECT  '政治' ,
         MIN(政治)
 FROM    ( SELECT TOP 60 PERCENT
                     政治
           FROM      cj
           ORDER BY  政治 DESC
         )y
 UNION ALL
 SELECT  '历史' ,
         MIN(历史)
 FROM    ( SELECT TOP 60 PERCENT
                     历史
           FROM      cj
           ORDER BY  历史 DESC
         )z
 UNION ALL
 SELECT  '物理' ,
         MIN(物理)
 FROM    ( SELECT TOP 60 PERCENT
                     物理 
 
           FROM      cj
           ORDER BY  物理 DESC
         )aa
 UNION ALL
 SELECT  '化学' ,
         MIN(化学)
 FROM    ( SELECT TOP 60 PERCENT
                     化学
           FROM      cj
           ORDER BY  化学 DESC
         )bb
 UNION ALL
 SELECT  '总分' ,
         MIN(总分)
 FROM    ( SELECT TOP 60 PERCENT
                     总分
           FROM      cj
           ORDER BY  总分 DESC
         ) cc