摘要:
2016-10-181. Coding: very simple, like tree pre-order traversal 2. search a number in ordered array without knowing the array length 3. leetcode 53 4. 阅读全文
摘要:
2015-3-11 phone under hr,coding is not required 1. Describe a project that you are post proud of.2. Which statistical method do you think is most over 阅读全文
摘要:
select d.name Department, e.name Employee, e.salary Salary from Employee einner join Department d on e.DepartmentId = d.idwhere (e.DepartmentId,e.sala 阅读全文
摘要:
CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INTBEGINdeclare M int;set M = N-1;RETURN ( # Write your MySQL query statement below. select distinc 阅读全文
摘要:
https://leetcode.com/problems/second-highest-salary/solution/two row has the same salary, should return null, so we use distinct salarySELECT IFNULL( 阅读全文