tag

#mysql

2 pages tagged

Practice › LeetCode › LeetCode (archived) › LeetCode 01xx ›

LeetCode 197: Rising Temperature

Problem Restatement We are given a table named Weather . Schema: Column Type id int recordDate date temperature int The id column is unique. There are no duplicate recordDate values. We need to find the id of every date where the temperature is higher than the temperature on the previous day. Example table: id recordDate temperature 1 2015-01-01 10 2 2015-01-02 25 3 2015-01-03 20 4 2015-01-04 30 Expected output:...

Practice › LeetCode › LeetCode (archived) › LeetCode 01xx ›

LeetCode 196: Delete Duplicate Emails

Problem Restatement We are given a table named Person . Schema: Column Type id int email varchar The id column is unique. Some rows may contain duplicate email addresses. We need to delete duplicate rows so that: Every email appears only once. The row with the smallest id is kept. All other duplicate rows are removed. Example table: id email 1 john@example.com 2 bob@example.com 3 john@example.com After deletion: id email...