摘要: 取三个以上连续的连续的行使得他们的人数大于100 X city built a new stadium, each day many people visit it and the stats are saved as these columns: id, date, people Please w 阅读全文
posted @ 2017-10-10 16:23 这个手杀不太0 阅读(257) 评论(0) 推荐(0) 编辑
摘要: 184. Department Highest Salary The Employee table holds all employees. Every employee has an Id, a salary, and there is also a column for the departme 阅读全文
posted @ 2017-08-27 21:42 这个手杀不太0 阅读(233) 评论(0) 推荐(0) 编辑
摘要: 181. Employees Earning More Than Their Managers The Employee table holds all employees including their managers. Every employee has an Id, and there i 阅读全文
posted @ 2017-08-27 21:05 这个手杀不太0 阅读(172) 评论(0) 推荐(0) 编辑
摘要: Write a SQL query to rank scores. If there is a tie between two scores, both should have the same ranking. Note that after a tie, the next ranking num 阅读全文
posted @ 2017-08-27 20:32 这个手杀不太0 阅读(399) 评论(0) 推荐(0) 编辑
摘要: Write a SQL query to get the nth highest salary from the Employee table. For example, given the above Employee table, the nth highest salary where n = 阅读全文
posted @ 2017-08-27 20:06 这个手杀不太0 阅读(185) 评论(0) 推荐(0) 编辑
摘要: Write a SQL query to get the second highest salary from the Employee table. For example, given the above Employee table, the query should return 200 a 阅读全文
posted @ 2017-08-27 20:02 这个手杀不太0 阅读(532) 评论(0) 推荐(0) 编辑
摘要: 118. Pascal's Triangle Given numRows, generate the first numRows of Pascal's triangle. For example, given numRows = 5,Return 阅读全文
posted @ 2017-08-21 00:08 这个手杀不太0 阅读(263) 评论(0) 推荐(0) 编辑
摘要: 204. Count Primes Count the number of prime numbers less than a non-negative number, n. 题意:计算小于非负数的质数数。 阅读全文
posted @ 2017-08-17 22:40 这个手杀不太0 阅读(255) 评论(0) 推荐(0) 编辑
摘要: 202. Happy Number Write an algorithm to determine if a number is "happy". A happy number is a number defined by the following process: Starting with a 阅读全文
posted @ 2017-08-17 22:03 这个手杀不太0 阅读(377) 评论(0) 推荐(0) 编辑
摘要: 41. First Missing Positive Given an unsorted integer array, find the first missing positive integer. For example,Given [1,2,0] return 3,and [3,4,-1,1] 阅读全文
posted @ 2017-08-14 23:58 这个手杀不太0 阅读(315) 评论(0) 推荐(0) 编辑