2015年4月19日
LeetCode - Rising Temperature
摘要： Description：Given a Weather table, write a SQL query to find all dates' Ids with higher temperature compared to its previous (yesterday's) dates. 选出比... 阅读全文
posted @ 2015-04-19 23:01 Pickle 阅读(274) 评论(0) 推荐(0) 编辑
LeetCode - Delete Duplicate Emails
摘要： Discription：Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest Id. 删除重... 阅读全文
posted @ 2015-04-19 22:16 Pickle 阅读(191) 评论(0) 推荐(0) 编辑
LeetCode - Customers Who Never Order
摘要： Description: Suppose that a website contains two tables, the Customers table and the Orders table. Write a SQL query to find all customers who never ... 阅读全文
posted @ 2015-04-19 21:55 Pickle 阅读(182) 评论(0) 推荐(0) 编辑