摘要: >Write a SQL query to find all duplicate emails in a table named Person.```+----+---------+| Id | Email |+----+---------+| 1 | a@b.com || 2 | c@d.... 阅读全文
posted @ 2015-08-03 22:42 卖程序的小歪 阅读(121) 评论(0) 推荐(0) 编辑
摘要: >The Employee table holds all employees. Every employee has an Id, a salary, and there is also a column for the department Id.```+----+-------+-------... 阅读全文
posted @ 2015-08-03 22:22 卖程序的小歪 阅读(143) 评论(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.```+----+-------... 阅读全文
posted @ 2015-08-03 22:06 卖程序的小歪 阅读(164) 评论(0) 推荐(0) 编辑
摘要: # 熟悉我熟悉xxx,其实很多原来熟悉到能背的,如果长时间不用了几乎也就忘了。此时再说自己熟悉XXX就被认为是在吹牛B了,感觉不是很好。所谓温故而知新,对于天资不聪颖的,就是要在一遍一遍的复习实践中慢慢理解掌握、获取别人可能一天就就明白记住的事情。# 表## 查看建表语句```show create... 阅读全文
posted @ 2015-08-03 21:38 卖程序的小歪 阅读(233) 评论(0) 推荐(0) 编辑
摘要: >Given two strings s and t, write a function to determine if t is an anagram of s.For example,s = "anagram", t = "nagaram", return true.s = "rat", t =... 阅读全文
posted @ 2015-08-03 21:12 卖程序的小歪 阅读(141) 评论(0) 推荐(0) 编辑
摘要: # forkfork产生的子进程是传统意义上的进程,fork之后执行路径就互不关联了,一旦fork返回后面的代码就在不用的进程上下文中执行了。到底是子进程先执行还是父进程先执行一般是随机的或者依赖实现的。# vforkvfork使得“子进程”先于“父进程”执行,子进程在父进程的进程空间中执行直到其调... 阅读全文
posted @ 2015-08-03 09:59 卖程序的小歪 阅读(292) 评论(0) 推荐(0) 编辑