2015年1月23日
LeetCode SQL: Second Highest Salary
摘要： select if(count(salary) = 0, NULL, salary) as `salary` from (select salary from Employee group by salary order by salary desc limit 1,1) tmpWrite a S... 阅读全文
posted @ 2015-01-23 00:36 卖程序的小歪 阅读(258) 评论(0) 推荐(0)
LeetCode SQL: Combine Two Tables
摘要： SELECT FirstName, LastName, City, State FROM Person pLEFT JOIN Address a ON p.PersonId = a.PersonId居然出SQL的题目了，左连接就行 阅读全文
posted @ 2015-01-23 00:09 卖程序的小歪 阅读(197) 评论(0) 推荐(0)
LeetCode Binary Search Tree Iterator
摘要： class BSTIterator {private: TreeNode* current; stack nodeStack;public: BSTIterator(TreeNode *root) { current = root; } /** @retu... 阅读全文
posted @ 2015-01-23 00:04 卖程序的小歪 阅读(148) 评论(0) 推荐(0)