摘要: Given a non negative integer number num. For every numbers i in the range 0 ≤ i ≤ num calculate the number of 1's in their binary representation and r 阅读全文
posted @ 2019-11-21 14:09 Schwifty 阅读(126) 评论(0) 推荐(0)
摘要: Write a SQL query to get the nth highest salary from the Employee table. + + + | Id | Salary | + + + | 1 | 100 | | 2 | 200 | | 3 | 300 | + + + For exa 阅读全文
posted @ 2019-11-21 13:52 Schwifty 阅读(143) 评论(0) 推荐(0)
摘要: Write a SQL query to get the second highest salary from the Employee table. + + + | Id | Salary | + + + | 1 | 100 | | 2 | 200 | | 3 | 300 | + + + For 阅读全文
posted @ 2019-11-21 13:32 Schwifty 阅读(111) 评论(0) 推荐(0)
摘要: The Employee table holds all employees. Every employee has an Id, a salary, and there is also a column for the department Id. + + + + + | Id | Name | 阅读全文
posted @ 2019-11-21 13:07 Schwifty 阅读(127) 评论(0) 推荐(0)
摘要: Table: Person + + + | Column Name | Type | + + + | PersonId | int | | FirstName | varchar | | LastName | varchar | + + + PersonId is the primary key c 阅读全文
posted @ 2019-11-21 13:07 Schwifty 阅读(199) 评论(0) 推荐(0)
摘要: Given a complete binary tree, count the number of nodes. Note: Definition of a complete binary tree from Wikipedia:In a complete binary tree every lev 阅读全文
posted @ 2019-11-21 11:44 Schwifty 阅读(204) 评论(0) 推荐(0)
摘要: There are a total of n courses you have to take, labeled from 0 to n-1. Some courses may have prerequisites, for example to take course 0 you have to 阅读全文
posted @ 2019-11-21 11:26 Schwifty 阅读(179) 评论(0) 推荐(0)