小弟,实在太笨,求一条sql语句...... select a ,max(b) as b from tablenamegroup by a 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select min(a) a,max(b)b from tablename yjdn(文刀无尽) 的正确的!!!!符合你的要求!!!!!!!!! select a,max(b) from tab1group by ahaving count(a)>1 sasacat(傻傻猫) 标准答案 select a,max(b) from tab1group by a select a ,max(b) as b from tablenamegroup by a select a ,max(b) as b from tablenamegroup by a这个查询的结果是 (1 4)有没有(2 4) 啊??? select a,max(b) from tab1group by ahaving count(a)>1正解!!!! 急求这个怎么写sql? oracle EBS R12克隆到50%出错问题 截取字符串 ORACLE9 怎样全库恢复? 向高手请教一个问题 请问一个查询的SQL语句怎么写啊??谢谢 关于asp调用oracle存储过程的问题 Window 2003 server 上安装Oracle8i问题。高手请进! 一个java程序传一个insert语句出错,怎么能在日志文件查看到出错信息?急 大家来看看这个SQL语句. 一个SQL查询的问题 ORACLE透明网关的错误
符合你的要求!!!!!!!!!
group by a
having count(a)>1
标准答案
group by a
from tablename
group by a
from tablename
group by a这个查询的结果是 (1 4)
有没有(2 4) 啊???
group by a
having count(a)>1正解!!!!