https://blog.youkuaiyun.com/lyf9901zh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/lyf9901/article/details/5965972https://blog.youkuaiyun.com/lyf9901/article/details/5965972lyf9901Tue, 26 Oct 2010 10:09:00 +0800(一)
1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断
select * from people
where peopleId in (select  peopleId  from  people  group  by  peopleId  having  count(peopleId) > 1)

2、删除表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断，只留有rowid最小的记录
d]]>https://blog.youkuaiyun.com/lyf9901/article/details/5895505https://blog.youkuaiyun.com/lyf9901/article/details/5895505lyf9901Sun, 19 Sep 2010 21:07:00 +0800https://blog.youkuaiyun.com/lyf9901/article/details/1541946https://blog.youkuaiyun.com/lyf9901/article/details/1541946lyf9901Mon, 26 Mar 2007 20:01:00 +0800 select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual;        A         A      ZERO     SPACE--------- --------- --------- ---------      ]]>https://blog.youkuaiyun.com/lyf9901/article/details/1541889https://blog.youkuaiyun.com/lyf9901/article/details/1541889lyf9901Mon, 26 Mar 2007 18:44:00 +0800