delete from A where a_id in (select id from B where b_id in (select id from C where c_id = ?))

相关推荐

• mysql 查询 not in not like和in like啥区别啊select * from aaaa where id in(1,2,3);select * from aaaa where id not in(1,2,3);select * from aaaa where tt like "%as%";select * from aaaa where tt not like "%as%";1 3我懂 2 4这个加了not是什么意思啊
• select distinct id from names where tid = 'AREACODE' And dsc like '%' || v_areacode
• 关于数据库Oracle的一道题a.course=b.能通俗点解析吗?select courseid as 课程ID,course as 课程名称,nvl(avg(grade),0) as 平均成绩,(select count(grade) from train a where grade
• SQL语句的where我想做个条件查询的,其中有两个条件,我现在想不限制条件的个数,就是说一个或者2个条件查询都可以.语句是：select * from table where id=1 and sno=2请问下where后面的条件有没能一定满足条件的通配符,就是说我想保留where 后面的sno=这个条件语句,但是我只要他满足了id=1就可以,后面还会有sno=（一个通配符使得它永远成立）.嘻嘻,哥自己想到了,但是还是谢谢3L和5L,是你们让我想到的,呼呼,我好开心啊select * from table where id=1 and （sno=‘传进来的值’ or ‘传进来的值'='null'）
• sql语句：去掉最大值,去掉最小值,算平均值SELECT AVG(Scores.Score)FROM ScoresWHERE ( ( (Scores.[ID]) = @id)AND (Score AND (Score > (SELECT MIN(Score) From Scores WHERE Scores.[ID] = @id) ) )如果出现相同的分数则计算结果会不对.会少一些分数我并不是想去除重复分数,而是比如100 20 30 40 40 60 100我希望：AVG（30+40+40+60+100）做高分有重复的话,只删除一个
• select distinct id from names where tid = 'AREACODE' And dsc like '%' || v_areacode其中dsc like '%' || v_areacode
• oracle语句报缺失表达式,貌似是decode用法不对?where t1.high_company_id =decode(c1.company_level,'4',select high_company_id from fnd_company_level where company_id= c1.company_id ,c1.company_id )
• 帮我解释下这个查询语句@select c_id,c_gcode,c_number into #11 from tb_bill_rg where c_id in(select c_id from tb_bill_r where datediff(day,c_au_time,'2007-04-01')=0 and c_ad_from like '2%') and c_gcode not in(select c_gcode from tb_d_sum_gdswhere c_number_move>0 and datediff(day,c_dt,'2007-04-01')=0 and c_adno like '2%') order by c_gcodeselect #11.c_id,#11.c_gcode,#11.c_number,tb_gds.c_name from #11,tb_gds where #11.c_gcode=tb_gds.c_gcodeorder by #11.c_gcode有很多地方不
• 奇怪的事情发生了.关于查询语法rs.open "select Top 24 * from news where BigClassName='广城' or BigClassName='深圳' or BigClassName='佛山' and ok=true order by id desc ",conn,1,1 为什么这里的ok=true 根本不起作用的///请问为什么.哪里写错了吗?ok为 布尔类型 数据库是ACCESS
• 如下题 请经常写存储过程 懂数据库Oracle 或者你知道如何写都帮帮我更新khexpinfo表的历史数据customer_id 的值,根据khexpInfo表的id与centerMaterialuseDetail表export_Uid关联,--centerMaterialuseDetail表的batchinfoUId与Batchinfo表的fuid关联,得到customer_id--用distinct关键字,如果结果记录数大于1则不需要处理,--否则就将khexinfo表的customer_id更新为所查出的customer_Id值-- 先根据khexpinfo的id查询,若记录数大于1则不执行第2条更新语句,否则执行第2条语句更新语句select distinct b.customer_id from centermaterialusedetail c ,batchinfo b where c.export_uid='154461' and c.batchinfo_uid=b.fuid;upd
• 某城市按以下规定收取每月煤气费:如果用气不超过60立方米,按0.80元每立方米付费;如果超过60立方米,超过部分按1.20元每立方米付费.已知某用户用煤气x立方米,则该户应交煤气费（）元
• 已知cosα-sinα=3√5/5,17π/12＜α＜7π/4,求sin2α和tan（π/4+α）