Leetcode-sql 50道
关注
分享
扫一扫
文章平均质量分 81
Smile sea breeze
人生不是百米冲刺，是马拉松赛跑，不是跑的快，而是跑的远
展开
专栏收录文章
- 默认排序
- 最新发布
- 最早发布
- 最多阅读
- 最少阅读
-
2542. Maximum Subsequence Score
2542. Maximum Subsequence Score原创 2024-09-11 09:23:23 · 809 阅读 · 0 评论 -
Leetcode sql 50汇总
Leetcode sql 50汇总原创 2024-08-27 04:24:06 · 583 阅读 · 0 评论 -
1517. Find Users With Valid E-Mails
1517. Find Users With Valid E-Mails原创 2024-08-26 10:37:45 · 976 阅读 · 0 评论 -
1327. List the Products Ordered in a Period
1327. List the Products Ordered in a Period原创 2024-08-26 03:43:24 · 710 阅读 · 0 评论 -
要将表中的多个值聚合到同一个 id 下的方法
要将表中的多个值聚合到同一个 id 下的方法原创 2024-08-26 03:28:44 · 258 阅读 · 0 评论 -
1484. Group Sold Products By The Date
1484. Group Sold Products By The Date原创 2024-08-26 03:27:05 · 601 阅读 · 0 评论 -
LIMIT 1 OFFSET 1 在sql中的具体使用方法
LIMIT 1 OFFSET 1 在sql中的具体使用方法原创 2024-08-25 23:21:33 · 841 阅读 · 0 评论 -
176. Second Highest Salary
176. Second Highest Salary原创 2024-08-25 23:18:11 · 829 阅读 · 0 评论 -
ROW_NUMBER() OVER (PARTITION BY email ORDER BY id) 如何理解
ROW_NUMBER() OVER (PARTITION BY email ORDER BY id) 如何理解原创 2024-08-25 22:54:05 · 247 阅读 · 0 评论 -
196. Delete Duplicate Emails
196. Delete Duplicate Emails原创 2024-08-25 22:52:27 · 711 阅读 · 0 评论 -
1527. Patients With a Condition
1527. Patients With a Condition原创 2024-08-25 22:22:43 · 577 阅读 · 0 评论 -
concat(upper(LEFT(name, 1)), lower(RIGHT(name, length(name)-1))) 如何理解
concat(upper(LEFT(name, 1)), lower(RIGHT(name, length(name)-1))) 如何理解原创 2024-08-25 22:05:52 · 359 阅读 · 0 评论 -
1667. Fix Names in a Table
1667. Fix Names in a Table原创 2024-08-25 22:02:26 · 627 阅读 · 0 评论 -
解释 DENSE_RANK() OVER (PARTITION BY D.id ORDER BY salary DESC)
解释 DENSE_RANK() OVER (PARTITION BY D.id ORDER BY salary DESC)原创 2024-08-25 19:55:17 · 325 阅读 · 0 评论 -
185. Department Top Three Salaries
185. Department Top Three Salaries原创 2024-08-25 19:51:44 · 920 阅读 · 0 评论 -
585. Investments in 2016
585. Investments in 2016原创 2024-08-25 19:28:03 · 989 阅读 · 0 评论 -
602. Friend Requests II: Who Has the Most Friends
602. Friend Requests II: Who Has the Most Friends原创 2024-08-25 19:15:12 · 531 阅读 · 0 评论 -
1341. Movie Rating
1341. Movie Rating原创 2024-08-25 18:57:40 · 573 阅读 · 0 评论 -
1321. Restaurant Growth
1321. Restaurant Growth原创 2024-08-24 20:49:47 · 705 阅读 · 0 评论 -
626. Exchange Seats
626. Exchange Seats原创 2024-08-24 20:47:14 · 636 阅读 · 0 评论 -
1978. Employees Whose Manager Left the Company
978. Employees Whose Manager Left the Company原创 2024-08-23 05:04:07 · 692 阅读 · 0 评论 -
1907. Count Salary Categories
1907. Count Salary Categories原创 2024-08-20 02:57:38 · 705 阅读 · 0 评论 -
UNION ALL 在 SQL中是什么意思
UNION ALL 在 SQL中是什么意思原创 2024-08-20 02:55:27 · 756 阅读 · 0 评论 -
1204. Last Person to Fit in the Bus
1204. Last Person to Fit in the Bus原创 2024-08-20 02:20:13 · 869 阅读 · 0 评论 -
SUM(weight) OVER (ORDER BY turn) AS cumulative_weight，over是什么意思
SUM(weight) OVER (ORDER BY turn) AS cumulative_weight，over是什么意思原创 2024-08-20 02:15:07 · 328 阅读 · 0 评论 -
1164. Product Price at a Given Date
1164. Product Price at a Given Date原创 2024-08-20 01:38:20 · 895 阅读 · 0 评论 -
180. Consecutive Numbers
180. Consecutive Numbers原创 2024-08-20 00:56:33 · 395 阅读 · 0 评论 -
610. Triangle Judgement
610. Triangle Judgement原创 2024-08-20 00:42:17 · 370 阅读 · 0 评论 -
1789. Primary Department for Each Employee
1789. Primary Department for Each Employee原创 2024-08-20 00:38:53 · 751 阅读 · 0 评论 -
1731. The Number of Employees Which Report to Each Employee
1731. The Number of Employees Which Report to Each Employee原创 2024-08-20 00:21:32 · 477 阅读 · 0 评论 -
1045. Customers Who Bought All Products
1045. Customers Who Bought All Products原创 2024-08-15 10:22:21 · 612 阅读 · 0 评论 -
619. Biggest Single Number
619. Biggest Single Number原创 2024-08-15 05:06:34 · 897 阅读 · 0 评论 -
1729. Find Followers Count
1729. Find Followers Count原创 2024-08-15 04:55:18 · 482 阅读 · 0 评论 -
596. Classes More Than 5 Students
596. Classes More Than 5 Students原创 2024-08-15 04:46:04 · 934 阅读 · 0 评论 -
1141. User Activity for the Past 30 Days I
1141. User Activity for the Past 30 Days I原创 2024-08-15 03:21:13 · 940 阅读 · 0 评论 -
2356. Number of Unique Subjects Taught by Each Teacher
2356. Number of Unique Subjects Taught by Each Teacher原创 2024-08-15 03:04:07 · 586 阅读 · 0 评论 -
550. Game Play Analysis IV
550. Game Play Analysis IV原创 2024-08-13 18:47:00 · 880 阅读 · 0 评论 -
1174. Immediate Food Delivery II
1174. Immediate Food Delivery II原创 2024-08-13 09:54:38 · 961 阅读 · 0 评论 -
SQL 中使格式化日期详细介绍
SQL 中使格式化日期详细介绍原创 2024-08-13 05:02:15 · 680 阅读 · 0 评论 -
1193. Monthly Transactions I
1193. Monthly Transactions I原创 2024-08-13 04:49:31 · 650 阅读 · 0 评论