oj-sql

题目

SQL115 删除记录（一）

思路

1. 简单删除语句；
2. timestampdiff 可取日期差值分钟数；

solution

delete where timestampdiff

delete from exam_record
where timestampdiff(MINUTE,start_time,submit_time)<5 and score<60;