select *
from ( select sum(L1) as s from tablename
union all
select sum(L2) from tablename
union all
select sum(L3) from tablename
......
union all
select sum(L100) from tablename
) a
group by s desc
解决方案 »
- 安装sql server 2008 R2时出错
- sql 2005 查询分析器是如何使用的?怎么和2000相差的那么大呀
- 交叉表问题,请教
- 存储过程里面怎样定义这条SQL语句吖?高手进来
- 求高手!SQL如何同时向一张表内插入多条记录
- sql 复杂查询,请大家帮帮忙
- 怎样根据日期是否过期生成一个 bit 类型的字段,高分!!!
- 如何在整个库中查找指定字符串?
- 各位大侠帮帮我
- 新学求助:C#连接数据库的窗体调试出现问题:未处理SQLCEEXCEPTION,无法加载与 8080 版本的 ADO.NET 提供程序相对应的 SQL Serv
- 一个高难度的报表,请教高手指导!
- 这种检测用户名及密码还有附加码是否正确的存储过程应该怎么写
上面按“发出回复”快了一点,要改一下:select *
from ( select sum(L1) as s from tablename
union all
select sum(L2) from tablename
union all
select sum(L3) from tablename
......
union all
select sum(L100) from tablename
) a
order by s desc
from ( select 1 as r,sum(L1) as s from tablename
union all
select 2,sum(L2) from tablename
union all
select 3,sum(L3) from tablename
......
union all
select 100,sum(L100) from tablename
) a
order by s desc
from ( select sum(L1) as s from tablename-----s
union all
select sum(L2) from tablename
union all
select sum(L3) from tablename
......
union all
select sum(L100) from tablename
) a
order by s desc---s1.只對s就可以進行降序排例嗎?請解釋?呵呵...2.偶是菜鳥!呵呵...