怎么在oracle 表里删除不需要的行 见上图,在“ENDNO”里面,有些值是“STARTNO”里没有的,怎么把这些值筛选出来,然后把其所在的一整行数据都删掉比如第2行的 ZQWJ002-2 在“STARTNO”里面就没有,就要把这一行记录删掉 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 -- 就是简单的删除吗?delete t where STARTNO is null delete from table t where t.startno not in (select distinct t.endno from table); delete from test t where not exists ( select 1 from test t1 where t1.STARTNO= t.ENDNO); delete from table t where t.endno not in (select startno from table); delete from table where startno is null DELETE FROM TABLE T WHERE T.endno NOT IN(SELECT DISTINCT endno FROM TABLE) DELETE FROM TABLE T WHERE T.endno NOT IN(SELECT DISTINCT endno FROM TABLE) DELETE FROM table WHERE startno IS NULL 一个简单的group by语句问题 想从事ORACLE开发,应该学些什么好 急急!!ORA-01092: ORACLE instance terminated. Disconnection forced oracle 分区表扩容 测试存储过程的时候报ora-01480的错误,怎么处理? 求一条分类SQL 那兒有oracle的學習教程的電子書呢??/ 高分急问各位xdjm,具体描述请看内容,来者都不胜感激! ora-12541 tns 没有监听器 关于oracle数据库,sql里面如何处理'单引号的插入 求SQL语句 oracle12c卸载
delete t where STARTNO is null
DELETE FROM TABLE T WHERE T.endno NOT IN(SELECT DISTINCT endno FROM TABLE)