2017年10月24日
[LeetCode] Second Highest Salary
摘要： Write a SQL query to get the second highest salary from the Employee table. For example, given the above Employee table, the query should return 200 a 阅读全文
posted @ 2017-10-24 11:52 immjc 阅读(145) 评论(0) 推荐(0)
[LeetCode] Delete Duplicate Emails
摘要： Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest Id. For example, aft 阅读全文
posted @ 2017-10-24 11:46 immjc 阅读(146) 评论(0) 推荐(0)
[LeetCode] Classes More Than 5 Students
摘要： There is a table courses with columns: student and class Please list out all classes which have more than or equal to 5 students. For example, the tab 阅读全文
posted @ 2017-10-24 11:34 immjc 阅读(493) 评论(0) 推荐(0)
[LeetCode] Rising Temperature
摘要： Given a Weather table, write a SQL query to find all dates' Ids with higher temperature compared to its previous (yesterday's) dates. + + + + | Id(INT 阅读全文
posted @ 2017-10-24 11:20 immjc 阅读(145) 评论(0) 推荐(0)
[LeetCode] Customers Who Never Order
摘要： Suppose that a website contains two tables, the Customers table and the Orders table. Write a SQL query to find all customers who never order anything 阅读全文
posted @ 2017-10-24 09:38 immjc 阅读(124) 评论(0) 推荐(0)