Hebbb.

想从一个dj_nsrxx表中取出不重复的前100条记录：select distinct a.nsrsbh,a.djxh,a.zgswjg from dj_nsrxx a where rownum <=100;这样执行后发现，实际只能查出少于100条的数据。原因是：执行时，是先返回100条记录，然后再distinct，假设有重复记录，那么实际返回的记录数会小于100。经查询资料发现：dist...

要实现的是：按最新时间排序，分页查询10条数据。 一、原来SQL：select * from (select rownum rn, to_char(t.create_date, 'yyyy-MM-dd') fbsj, t.* from t_user_receive t order by t.create_date desc) where r...

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