一个数据库的面试题! 一个学生表Student(s_id,s_name)存在很多完全一样的记录,怎么把它们删除. 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 delete student where rowid not in (select max(rowid) from student group by s_id,s_name);commit; DELETE student t WHERE ROWID != (SELECT MAX(ROWID) FROM student t WHERE a.student_id = t.student_id); with leno as(select s_id,rownumber()over(partition by s_id,s_name order by s_id,s_name) rowid from student)delete from leno where rowid >= 2 用ROWID删除时最快的了结帖率:102.17% 强 with leno as(select s_id,rownumber()over(partition by s_id,s_name order by s_id,s_name) rowid from student)delete from leno where rowid >= 2 请问一下测试这个存储过程sql语句怎么写啊? oracle里写个存储过程循环插入10万条记录 表关联获取数据的问题! 求教SQL问题~帮忙看看好么? 用select得到不同的纪录怎么写 客户端连接服务器的问题 高分求助:oracle9i的data guaid实例或技术文档 oracle安装 表坏了,谁能救我??? 大家忙帮一下各位在座的大哥们,小弟在线等待。 为什么停止OracleDBConsole服务,数据库就变快了 能否读取ORACLE表中的备注信息?
WHERE ROWID != (SELECT MAX(ROWID) FROM student t WHERE a.student_id = t.student_id);
(select s_id,rownumber()over(partition by s_id,s_name order by s_id,s_name) rowid from student
)
delete from leno
where rowid >= 2
(select s_id,rownumber()over(partition by s_id,s_name order by s_id,s_name) rowid from student
)
delete from leno
where rowid >= 2