2015年3月9日

Duplicate Emails

摘要： Write a SQL query to find all duplicate emails in a table namedPerson.+----+---------+| Id | Email |+----+---------+| 1 | a@b.com || 2 | c@d.com |... 阅读全文

posted @ 2015-03-09 21:01 luckygxf 阅读(207) 评论(0) 推荐(0) 编辑

Customers Who Never Order

摘要： 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-03-09 20:23 luckygxf 阅读(238) 评论(0) 推荐(0) 编辑

Repeated DNA Sequences

摘要： All DNA is composed of a series of nucleotides abbreviated as A, C, G, and T, for example: "ACGAATTCCG". When studying DNA, it is sometimes useful to ... 阅读全文

posted @ 2015-03-09 16:33 luckygxf 阅读(156) 评论(0) 推荐(0) 编辑

Median of Two Sorted Arrays

摘要： There are two sorted arrays A and B of size m and n respectively. Find the median of the two sorted arrays. The overall run time complexity should be ... 阅读全文

posted @ 2015-03-09 14:32 luckygxf 阅读(181) 评论(0) 推荐(0) 编辑

Reverse Bits

摘要： Reverse bits of a given 32 bits unsigned integer.For example, given input 43261596 (represented in binary as00000010100101000001111010011100), return ... 阅读全文

posted @ 2015-03-09 11:33 luckygxf 阅读(176) 评论(0) 推荐(0) 编辑

导航