小弟不才,求一条sql语句 select name, sum(num) num from tab_ group by name 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select name, sum(num) numfrom tab_group by name select name, sum(num) num from tabname group by nameorder by num desc select name, sum(num) numfrom tab_group by name select name,sum(num)num from tablename group by name order by num desc; select name, sum(num) num from tabname group by nameorder by num desc 这样有点意思:select name, sum(num)from tablenamegroup by nameorder by 2 desc select name, sum(num) num from tabname group by nameorder by num desc 楼主,别给我分;只是说明一下,这种问题今后建议不要提,自己能不能稍微勤快一点;如果真要提最多给5分就够了,否则真是有嫌疑!不是谁都有时间在csdn上为分数而来的。 sql server 2005 数据 导入 oracle sql查询日期型字段 oracle如何查对范围进行多条查询 查询每月数据,如何消除笛卡尔积,麻烦各位大虾指点 请问怎么知道某个表放于哪个表空间? 求助!!! 紧急求一个表延迟更新的触发器 请看这个错误 如何在声明中使用判断语句? orcle 存储过程中 loop无法停止。 数据库导入imp要求输入口令的问题 commit 有什么用, 写不写 不都一样吗?
from tab_
group by name
from tabname
group by name
order by num desc
from tab_
group by name
from tablename
group by name
order by num desc;
from tabname
group by name
order by num desc
from tablename
group by name
order by 2 desc
from tabname
group by name
order by num desc
只是说明一下,这种问题今后建议不要提,自己能不能稍微勤快一点;如果真要提最多给5分就够了,否则真是有嫌疑!不是谁都有时间在csdn上为分数而来的。