请问这个SQL语句怎么写?谢谢了 select a1.namefrom a1,a2where substring(a1.id,1,4) = a2.aid and a2.aname = '2000级' 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select a.name from a where substr(to_char(a.id),1,4) = select to_char(b.id) from b where b.aname='2000级' select a1.name from a1,a2where substring(a1.id,1,4) = a2.aid select a1.name from a1,a2where substring(a1.id,1,4) = a2.aidand a2.aname = 你輸入的參數 select a1.name from a1,a2 where substring(a1.id,1,4) = a2.aid and a2.aname ='2001级' 都写完了,来一个不一样的。select * from a1where substring(id,1,4) = (select aid from a2 where aname = '2001级') select * from a1 where substr(a1.id,1,4) in (select a2.aid from a2 where a2.ananme='你的输入') 在sql*plus 中输入:accept var_aname 'please enter aname:'select a1.namefrom a1,a2where substring(a1.id,1,4) = a2.aid and a2.aname = '&var_name' 这样简单点:)select a1.namefrom a1,a2where substring(a1.id,1,4) = a2.aid and a2.aname = '&var_name' select name from a1 where exists(select 1 from a2 where substr(a1.id,1,4)=a2.aid and a2.aname='...') 急急急!提高查询效率 oracle 问题 求助 请教行变列的具体问题。。。 相同的表结构,存储过程可以在817上编译9i上为什么不行? 怎么把这几个update语句整成一句呢? 如何查找重复字段中第一条记录? 请问按照我指定的顺序排序的sql语句如何写? ******系统强制结帖通知****** 在SCO5.04中安装ORACLE7.3.2出错,快来指教啊? ★★怎么获得计算机名称或者IP地址★★ 关于Rapid SQL连接Oracle数据库的问题 一个简单问题??~(我分少,但我守信誉,一有正确答案,立刻结贴!!急!!!!)
where substring(a1.id,1,4) = a2.aid
where substring(a1.id,1,4) = a2.aid
and a2.aname = 你輸入的參數
where substring(id,1,4) = (select aid from a2 where aname = '2001级')
select a1.name
from a1,a2
where substring(a1.id,1,4) = a2.aid
and a2.aname = '&var_name'
from a1,a2
where substring(a1.id,1,4) = a2.aid
and a2.aname = '&var_name'