简单的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; insert難題,高手進 关于SQLStudio里连接oracle数据库怎么做? [提问]refcursor是一种数据类型吗? 一个关于sql语句如何实现问题 8I客户端能不能连接10G服务器 PL——SQL 问题? 在WHERE子句中能否用数组? 高分求一存储过程,对于高手来说很简单。(马上结贴) 为什么表空间大小不能超过4G? 下面两个操作,哪种效率高一些?或者还有什么更好的方法,谢谢! 菜菜问题 如何导入数据
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;