摘要: 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 @ 2019-01-10 17:21 fatttcat 阅读(145) 评论(0) 推荐(0) 编辑
摘要: Table: Person Table: Address Write a SQL query for a report that provides the following information for each person in the Person table, regardless if 阅读全文
posted @ 2019-01-10 17:15 fatttcat 阅读(122) 评论(0) 推荐(0) 编辑
摘要: There is a table World A country is big if it has an area of bigger than 3 million square km or a population of more than 25 million. Write a SQL solu 阅读全文
posted @ 2019-01-10 17:08 fatttcat 阅读(162) 评论(0) 推荐(0) 编辑
摘要: Given a Binary Search Tree (BST) with the root node root, return the minimum difference between the values of any two different nodes in the tree. Exa 阅读全文
posted @ 2019-01-10 17:00 fatttcat 阅读(155) 评论(0) 推荐(0) 编辑
摘要: Given a list of words and two words word1 and word2, return the shortest distance between these two words in the list. Example:Assume that words = ["p 阅读全文
posted @ 2019-01-10 16:33 fatttcat 阅读(148) 评论(0) 推荐(0) 编辑
摘要: Given a non-empty array of integers, every element appears three times except for one, which appears exactly once. Find that single one. Note: Your al 阅读全文
posted @ 2019-01-10 14:39 fatttcat 阅读(100) 评论(0) 推荐(0) 编辑
摘要: Given a binary tree, return the vertical order traversal of its nodes' values. (ie, from top to bottom, column by column). If two nodes are in the sam 阅读全文
posted @ 2019-01-10 08:51 fatttcat 阅读(147) 评论(0) 推荐(0) 编辑