简单的sql问题,希望大虾赐教! select a1,a2,max(b3) from a,b where a1 = b2 group by a1,a2 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select a.a1,a.a2,b.b3 from a,b where a.a1 = (select b.b2 from b where b.rowid != (select max(rowid) from b where b.b2=a.a1)); select a.a1,a.a2,b.b3 from a,(select * from b where b1 in (select min(b1) from b group by b2 ))bwhere a.a1=b.b2; 可以这样写:select * from (select a.a1, a.a2, b.3 from a, b where a.a1 = b.b2) c where c.rownum = 1; 数据库不存在查询 为什么没有PROCEDURE_NAME呢 oralce privs 如何Oracle存储过程,函数,触发器的文本进行加密 怎样获取oracle服务器中的所有数据库名 更新表SQL语句 求一aix下oracle 10g的自动备份脚本 oracle的***.dmp数据文件imp导入不成功,都有哪些原因?大家谈谈,谢谢! 面试中常会问到的问题,希望大家给个答案!! 请问哪里有Developer/2000??? 菜菜问题 如何导入数据
where a.a1 = (select b.b2 from b
where b.rowid != (select max(rowid) from b where b.b2=a.a1));
(select * from b where b1 in (select min(b1) from b group by b2 ))b
where a.a1=b.b2;
from (select a.a1, a.a2, b.3 from a, b where a.a1 = b.b2) c
where c.rownum = 1;