摘要: You are standing at position 0 on an infinite number line. There is a goal at position target. On each move, you can either go left or right. During t 阅读全文
posted @ 2019-01-13 16:55 bernieloveslife 阅读(146) 评论(0) 推荐(0) 编辑
摘要: 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-13 16:34 bernieloveslife 阅读(103) 评论(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-13 16:33 bernieloveslife 阅读(97) 评论(0) 推荐(0) 编辑
摘要: Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest Id. For example, aft 阅读全文
posted @ 2019-01-13 16:30 bernieloveslife 阅读(120) 评论(0) 推荐(0) 编辑
摘要: Given a text file file.txt that contains list of phone numbers (one per line), write a one liner bash script to print all valid phone numbers. You may 阅读全文
posted @ 2019-01-13 16:25 bernieloveslife 阅读(119) 评论(0) 推荐(0) 编辑