oj-sql

题目

SQL116 删除记录（二）

思路

1. 简单删除语句；

solution

delete where limit

delete from exam_record
where submit_time is null or timestampdiff(minute,start_time,submit_time)<5
order by start_time
limit 3;