sql常见面试(2)
摘要:
1.sql 删除表中重复数据保留一条 1)删除表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断,只留有rowid最小的记录 delete from people where peopleName in (select peopleName from people group by 阅读全文
posted @ 2019-09-20 14:35 有酒有故事 阅读(241) 评论(0) 推荐(0) 编辑