196 删除重复的电子邮箱
题目连接:196.删除重复的电子邮箱
解答:
delete p1 from Person p1,Person p2 where p1.email = p2.email and p1.id > p2.id;
197 上升的温度
题目连接:197.上升的温度
解答:
select p1.id Id from Weather p1,Weather p2 where datediff(p1.recordDate,p2.recordDate)=1 and p1.temperature>p2.temperature;