一、删除冗余记录
DELETE [学生表] WHERE id NOT IN (SELECT MIN(id) FROM [学生表] GROUP BY [学号],[姓名],[课程编号],[课程],[分数])
sql server ，sql语句，练习笔记
原文：http://www.cnblogs.com/mokeyish/p/5046829.html
