编程语言
文章平均质量分 68
capf2202
这个作者很懒,什么都没留下…
展开
-
183.Customers Who Never Order题解
题目分析:一个包含Customers的顾客表和Orders的订单表,两个表。通过SQL找到从没有过订单的顾客。可以用NOT IN,NOT EXISTS。 SQL语句:1.使用NOT IN(Accepted 777ms): SELECT Name FROM Customers c WHERE c.Id NOT IN (SELECT CustomerId FROM Orders o)原创 2017-06-04 20:45:31 · 170 阅读 · 0 评论 -
181. Employees Earning More Than Their Managers解题
题目分析:雇员表有所有员工的信息。所有员工和经理都有ID。给定雇员表,通过编写SQL找到工资比经理多的员工的姓名。上表中,只有Joe工资比经理多。此题采用自连接SQL语句:SELECT a.NAME FROM Employee a, Employee b WHERE a.ManagerId = b.Id AND a.Salary > b.Salary;原创 2017-06-04 21:09:37 · 204 阅读 · 0 评论 -
.ZigZag Conversion题目分析
题目6.ZigZag ConversionThe string "PAYPALISHIRING" is written in a zigzag pattern on a given number of rows like this: (you may want to display this pattern in a fixed font for better legi原创 2017-05-21 23:27:43 · 191 阅读 · 0 评论 -
11. Container With Most Water题解
DescriptionHintsSubmissionsSolutionsTotal Accepted: 132924Total Submissions: 365451Difficulty: MediumContributor: LeetCodeGiven n non-negative integers a1, a2, ..., an,原创 2017-06-18 20:25:53 · 141 阅读 · 0 评论 -
15. 3Sum题解
Given an array S of n integers, are there elements a, b, c in S such that a + b + c = 0? Find all unique triplets in the array which gives the sum of zero.Note: The solution set must not contain原创 2017-06-18 20:34:31 · 149 阅读 · 0 评论 -
19. Remove Nth Node From End of List题解
Given a linked list, remove the nth node from the end of list and return its head.For example, Given linked list: 1->2->3->4->5, and n = 2. After removing the second node from the end, the原创 2017-06-18 20:44:34 · 136 阅读 · 0 评论 -
17. Letter Combinations of a Phone Number题解
Given a digit string, return all possible letter combinations that the number could represent.A mapping of digit to letters (just like on the telephone buttons) is given below.Input:Digit st原创 2017-06-18 22:03:17 · 204 阅读 · 0 评论 -
20. Valid Parentheses题解
DescriptionHintsSubmissionsSolutionsTotal Accepted: 202731Total Submissions: 611689Difficulty: EasyContributor: LeetCodeGiven a string containing just the characters '(',原创 2017-06-18 22:09:44 · 178 阅读 · 0 评论 -
24. Swap Nodes in Pairs题解
DescriptionHintsSubmissionsSolutionsTotal Accepted: 162390Total Submissions: 427247Difficulty: MediumContributor: LeetCodeGiven a linked list, swap every two adjacent nod原创 2017-06-18 23:04:13 · 187 阅读 · 0 评论