知了的博客

1、查询表中重复数据。select * from peoplewhere peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)2、删除表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断，只留有rowid最小的记录d...

比方说在A表中存在一个字段“name”，而且不同记录之间的“name”值有可能会相同，现在就是需要查询出在该表中的各记录之间，“name”值存在重复的项；Select Name,Count(*) From A Group By Name Having Count(*) > 1如果还查性别也相同则如下:Select Name,sex,Count(*) From A Gro...

select t1.sid, t1.serial#, t1.username, t1.logon_time from v$session t1, v$locked_object t2 where t1.sid = t2.session_id order by t1.logon_time alter system kill session '615,12587'

[code="java"]public void updateKpiStatus(String kpiStatus,String taskId){ Connection dbc=null; Statement stmt=null; PreparedStatement ps=null; try { dbc = new DBConn().getNewConnection();...

一、rank()/dense_rank() over(partition by ...order by ...)现在客户有这样一个需求，查询每个部门工资最高的雇员的信息，相信有一定oracle应用知识的同学都能写出下面的SQL语句：[code="java"] select e.ename, e.job, e.sal, e.deptno from scott.emp e, ...