关于SQL语句的问题,请高手帮忙,急!! select min(id),name ,sum(cast(b as int)),sum(cast(c as int)),sum(cast(d as int))from yourtable group by name 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select id,name ,sum(b) b,sum(c) c sum(d) dfrom 表group by id,name select min(id),name ,sum(cast(b as int)),sum(cast(c as int)),sum(cast(d as int))from yourtable group by name having count(1)>1 select id,name ,sum(b) b,sum(c) c sum(d) dfrom 表group by id,name SELECT *FROM table aWHERE (id = (SELECT MIN(id) FROM table WHERE name = a.name)) select * from tablewhere name in(select name from tablegroup by name having count(name)>1) select id,name ,sum(b) b,sum(c) c sum(d) dfrom 表group by id,name SQL安装问题 联合多个表(Inner Join) 用存储过程备份数据库 请问在下SQL下如何在自定义函数那定义个十进制转十六进制的函数,要如何写?急求 求SQL语句 外键和默认约束 关于回滚,望各位大侠帮忙!!!! vfp向导生成的工程在别的计算机上出现文件目录错误。 这样用触发器会不会形成死循环? 请大家评论一下机械工业出版社的Oracle8系列丛书!!! 如何将openquery作为Update的表名,语法如何...解决马上给分... 求:给出任意会员ID,计算出其下级人数,及包含的级数?SQL语句及实现?
from 表
group by id,name
from yourtable group by name having count(1)>1
from 表
group by id,name
FROM table a
WHERE (id =
(SELECT MIN(id)
FROM table
WHERE name = a.name))
where name in
(select name from table
group by name
having count(name)>1)
from 表
group by id,name