摘要:
前几天去一个软件公司面试,期间面试官让我做了几道笔试题,有一道印象比较深刻!public class Test { public static void test(Object obj){ System.out.println("one"); } public static void test(... 阅读全文
摘要:
1、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断[sql] view plaincopyprint?select*frompeoplewherepeopleIdin(selectpeopleIdfrompeoplegroupbypeopleIdhavingcount(peopleId)>1)select * from peoplewhere peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1) 2、删除表中多余的重复记录,重复记录是根据 阅读全文