- 博客(9)
- 资源 (2)
- 收藏
- 关注
原创 181. Employees Earning More Than Their Managers
The Employee table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id.+----+-------+--------+-----------+| Id | Name | Salary |
2016-08-30 12:47:41 403
原创 182. Duplicate Emails
Write a SQL query to find all duplicate emails in a table named Person.+----+---------+| Id | Email |+----+---------+| 1 | a@b.com || 2 | c@d.com || 3 | a@b.com |+----+---------+For
2016-08-30 09:25:18 520
原创 183. Customers Who Never Order
Suppose that a website contains two tables, the Customers table and the Orders table. Write a SQL query to find all customers who never order anything.Table: Customers.+----+-------+| Id | Na
2016-08-30 09:17:27 463
原创 196. Delete Duplicate Emails
Write a SQL query to delete all duplicate email entriesin a table named Person, keeping only unique emails based on its smallest Id.+----+------------------+| Id | Email |+----+----
2016-08-29 22:46:41 574
原创 197. Rising Temperature
Given a Weather table,write a SQL query to find all dates' Ids with higher temperature compared toits previous (yesterday's) dates.+---------+------------+------------------+| Id(INT) | Date(D
2016-08-29 22:45:18 488
原创 函数重载
1.C++允许多个函数拥有相同的名字,只要它们的参数列表不同就可以。这就是函数的重载(Function Overloading)。借助重载,一个函数名可以有多种用途。2.实例//参数类型不同 int max(int a,int b,int c);double max(double a,double b,double c);//参数个数不同 int max(int a,int b,
2016-08-28 17:49:04 456
原创 驱动模块(driver) 和桩模块(stub)
传统的单元测试包括了驱动模块(driver) 和桩模块(stub)。驱动模块的目的很单纯,就是为了访问类库的属性和方法,来检测类库的功能是否正确;驱动模块驱动模块是用来模拟被测试模块的上一级模块,相当于被测模块的主程序。它接收数据,将相关数据传送给被测模块,启用被测模块,并打印出相应的结果。驱动模块(Driver)可以通过模拟一系列用户操作行为,比如选择用户界面上的某一个选项或
2016-08-16 09:08:44 8218 1
原创 快速排序一次排序的应用
1.将数组中的大写字母与小写字母分开例子:一个数组中存储有且仅有大写和小写字母,编写一个函数对数组内的字母重新排列,让小写字母在大写字母之前#include#includeusing namespace std;//判断是否为大写字母 bool isUpper(char a){ if(a>='A' && a<='Z') return true; return fals
2016-08-13 17:55:00 879
原创 原地归并排序
原地归并排序原地归并排序不需要辅助数组既可以归并。关键在于merge函数。假设有两段递增的子数组arr[begin...mid-1]和arr[mid..end].但是整个数组不是递增的。其中i=begin,j=mid,k=end第一步:i往后移动,找到第一个arr[i]>arr[j]的索引,假设数组元素如下图所示,图中arr[i]=2,则i经过此步骤之后指向arr[5]
2016-08-10 12:51:36 590
MATLAB7_0基础教程_清华大学.pdf
2015-01-25
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人