一、删除冗余记录
DELETE [学生表] WHERE id NOT IN (SELECT MIN(id) FROM [学生表] GROUP BY [学号],[姓名],[课程编号],[课程],[分数])
原标题:sql server ,sql语句,练习笔记
关键词:sql