cte2 as ( select product_id, new_price from ( select product_id, new_price, dense_rank() over(partition by product_id order by change_date desc) rnk from products where change_date <= '2019-08-16' ) t where rnk = 1 ## 离8.16当天最近的一天(包括当天也可能最近一天) ) select...
# 这道题比较简单,用不到Product表。 # 按seller_id分组,求出每个seller的price总和,最大的输出即可。 SELECT seller_id FROM Sales GROUP BY seller_id HAVING SUM(price)=(SELECT MAX(total) FROM ( SELECT seller_id, SUM(price) as total FROM Sales GROUP BY seller_id ) t1 ) NO.34 中等 (109...
713 乘积小于K的子数组 - Subarray Product Less Than K C# C++ Java Python Medium 712 两个字符串的最小ASCII删除和 - Minimum ASCII Delete Sum for Two Strings C# C++ Java Python Medium 711 C# C++ Java Python Hard 710 黑名单中的随机数 - Random Pick with Blacklist C# C++ Java Python Hard ...
181 Employees Earning More Than Their Managers employees-earning-more-than-their-managers.sql 自连接 182 Duplicate Emails duplicate-emails.sql 查找重复元素 183 Customers Who Never Order customers-who-never-order.sql 左连接不包含内连接 184 Department Highest Salary department-highest-salary.sql 左...
712 Minimum ASCII Delete Sum for Two Strings 55.4% Medium 713 Subarray Product Less Than K 37.4% Medium 714 Best Time to Buy and Sell Stock with Transaction Fee 51.4% Medium 718 Maximum Length of Repeated Subarray 47.1% Medium 721 Accounts Merge 42.1% Medium 722 Remove Comments 31.8%...
181 Employees Earning More Than Their Managers 50.1% Easy 182 Duplicate Emails 56.4% Easy 183 Customers Who Never Order 46.5% Easy 189 Rotate Array 31.2% Easy 190 Reverse Bits 32.7% Easy 191 Number of 1 Bits 44.6% Easy 193 Valid Phone Numbers 25.4% Easy 195 Tenth Line 33.9% Ea...
713 Subarray Product Less Than K Algorithms Medium 712 Minimum ASCII Delete Sum for Two Strings Algorithms Medium 699 Falling Squares Algorithms Hard 698 Partition to K Equal Sum Subsets Algorithms Medium 697 Degree of an Array Algorithms Easy 696 Count Binary Substrings Algorithms Easy 695 Max Area...
0712 Minimum ASCII Delete Sum for Two Strings 58.5% Medium 0713 Subarray Product Less Than K Go 39.1% Medium 0714 Best Time to Buy and Sell Stock with Transaction Fee Go 54.7% Medium 0715 Range Module Go 38.5% Hard 0716 Max Stack 42.6% Easy 0717 1-bit and 2-bit Characters Go ...
#318. Maximum Product of Word Lengths (M) 1500 #898. Bitwise ORs of Subarrays (M+) 1600 #1178. Number of Valid Words for Each Puzzle (H-) 1700 #1290. Convert Binary Number in a Linked List to Integer (E) 900 #1371. Find the Longest Substring Containing Vowels in Even Cou...
14 Longest Common Prefix 34.1%Easy 20 Valid Parentheses 37.1%Easy 21 Merge Two Sorted Lists 48.6%Easy 26 Remove Duplicates from Sorted Array 41.7%Easy 27 Remove Element 45.4%Easy 28 Implement strStr() 32.8%Easy 35 Search Insert Position