![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
leetcode
Mr.Nobody
这个作者很懒,什么都没留下…
展开
-
Duplicate Emails
Write a SQL query to find all duplicate emails in a table named Person.+—-+———+ | Id | Email | +—-+———+ | 1 | a@b.com | | 2 | c@d.com | | 3 | a@b.com | +—-+———+ For example, your query shou原创 2015-10-07 22:40:36 · 449 阅读 · 0 评论 -
Peeking Iterator
Given an Iterator class interface with methods: next() and hasNext(), design and implement a PeekingIterator that support the peek() operation – it essentially peek() at the element that will be return原创 2015-09-26 21:06:24 · 254 阅读 · 0 评论 -
Word Pattern
Word PatternMy SubmissionsQuestion Solution Total Accepted: 1488 Total Submissions: 5360 Difficulty: EasyGiven a pattern and a string str, find if str follows the same patt转载 2015-10-06 13:20:25 · 362 阅读 · 0 评论 -
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.+—-+——————+ | Id | Email | +—-+——————+ | 1 | john@exa原创 2015-10-23 10:10:25 · 333 阅读 · 0 评论 -
Rising Temperature
https://leetcode.com/problems/rising-temperature/# Write your MySQL query statement belowselect w1.Id from Weather w1,Weather w2 where TO_DAYS(w1.Date) = TO_DAYS(w2.Date) + 1 AND w1.Temperature > w2.T原创 2015-10-07 22:25:31 · 328 阅读 · 0 评论 -
Second Highest Salary
Write a SQL query to get the second highest salary from the Employee table.+—-+——–+ | Id | Salary | +—-+——–+ | 1 | 100 | | 2 | 200 | | 3 | 300 | +—-+——–+ For example, given the above原创 2015-10-07 17:14:02 · 322 阅读 · 0 评论