2015年3月10日

Number of 1 Bits

摘要: Write a function that takes an unsigned integer and returns the number of ’1' bits it has (also known as theHamming weight).For example, the 32-bit in... 阅读全文

posted @ 2015-03-10 17:11 luckygxf 阅读(186) 评论(0) 推荐(0) 编辑

Combine Two Tables

摘要: Table:Person+-------------+---------+| Column Name | Type |+-------------+---------+| PersonId | int || FirstName | varchar || LastName ... 阅读全文

posted @ 2015-03-10 15:29 luckygxf 阅读(201) 评论(0) 推荐(0) 编辑

Second Highest Salary

摘要: Write a SQL query to get the second highest salary from theEmployeetable.+----+--------+| Id | Salary |+----+--------+| 1 | 100 || 2 | 200 || ... 阅读全文

posted @ 2015-03-10 15:01 luckygxf 阅读(150) 评论(0) 推荐(0) 编辑

Employees Earning More Than Their Managers

摘要: TheEmployeetable holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id.+----+-------+-... 阅读全文

posted @ 2015-03-10 14:30 luckygxf 阅读(255) 评论(0) 推荐(0) 编辑

导航