2015年8月7日
*Delete Duplicate Emails
摘要： 题目：Write a SQL query to delete all duplicate email entries in a table namedPerson, keeping only unique emails based on itssmallestId.+----+-----------... 阅读全文
posted @ 2015-08-07 10:47 Hygeia 阅读(144) 评论(0) 推荐(0)
Rising Temperature [MySQL]
摘要： 题目：Given aWeathertable, write a SQL query to find all dates' Ids with higher temperature compared to its previous (yesterday's) dates.+---------+-----... 阅读全文
posted @ 2015-08-07 10:27 Hygeia 阅读(187) 评论(0) 推荐(0)