摘要:
Suppose that a website contains two tables, theCustomerstable and theOrderstable. Write a SQL query to find all customers who never order anything.Tab...
阅读全文
posted @ 2015-06-10 17:54
gone~with~wind
阅读(107)
推荐(0)
编辑
摘要:
Write a SQL query to find all numbers that appear at least three times consecutively.+----+-----+| Id | Num |+----+-----+| 1 | 1 || 2 | 1 || 3 ...
阅读全文
posted @ 2015-06-10 17:31
gone~with~wind
阅读(326)
推荐(0)
编辑
摘要:
Table:Person+-------------+---------+| Column Name | Type |+-------------+---------+| PersonId | int || FirstName | varchar || LastName ...
阅读全文
posted @ 2015-06-10 17:17
gone~with~wind
阅读(135)
推荐(0)
编辑
摘要:
Given a set ofnon-overlappingintervals, insert a new interval into the intervals (merge if necessary).You may assume that the intervals were initially...
阅读全文
posted @ 2015-06-10 16:42
gone~with~wind
阅读(147)
推荐(0)
编辑
摘要:
Given an unsorted integer array, find the first missing positive integer.For example,Given[1,2,0]return3,and[3,4,-1,1]return2.Your algorithm should ru...
阅读全文
posted @ 2015-06-10 15:15
gone~with~wind
阅读(130)
推荐(0)
编辑