leetcode 181. Employees Earning More Than Their Managers
来源:互联网 发布:加工中心中心钻编程 编辑:程序博客网 时间:2024/06/08 19:31
Employees Earning More Than Their Managers
1. 建表
create table if not exists Employee_181 ( Id int(10) not null auto_increment, Name varchar(20) default null, Salary int(20) default null, ManagerId int(20) default null, primary key(Id))ENGINE=InnoDB DEFAULT CHARSET=utf8insert into Employee_181(Name, Salary, ManagerId) values ('Joe', 70000, 3);insert into Employee_181(Name, Salary, ManagerId) values ('Henry', 80000, 4);insert into Employee_181(Name, Salary) values ('Sam', 60000);insert into Employee_181(Name, Salary) values ('Max', 90000);
2 .测试
select E1.name as Employeefrom Employee_181 as E1, Employee_181 as E2where E1.ManagerId = E2.Id and E1.Salary > E2.Salary;
3。答案
select E1.name as Employeefrom Employee as E1, Employee as E2where E1.ManagerId = E2.Id and E1.Salary > E2.Salary;
练习:查找ManagerId 不为空的
select Id, Name from Employee_181 where ManagerId is not null ;
SQL基础测试
1.SQL 指的是?您的回答:Structured Query Language2.哪个 SQL 语句用于从数据库中提取数据?您的回答:SELECT3.哪条 SQL 语句用于更新数据库中的数据?您的回答:UPDATE4.哪条 SQL 语句用于删除数据库中的数据?您的回答:DELETE5.哪条 SQL 语句用于在数据库中插入新的数据?您的回答:INSERT INTO6.通过 SQL,您如何从 "Persons" 表中选取 "FirstName" 列?您的回答:SELECT FirstName FROM Persons7.通过 SQL,您如何从 "Persons" 表中选取所有的列?您的回答:SELECT * FROM Persons8.通过 SQL,您如何从 "Persons" 表中选取 "FirstName" 列的值等于"Peter" 的所有记录?您的回答:SELECT * FROM Persons WHERE FirstName='Peter'9.通过 SQL,您如何从 "Persons" 表中选取 "FirstName" 列的值以 "a" 开头的所有记录?您的回答:SELECT * FROM Persons WHERE FirstName LIKE 'a%'10.请判断下列说法是否正确:当所列出的某个条件为 true 时,OR 运算符会显示记录。当列出的所有条件为 true 时,AND 运算符会显示记录。您的回答:正确11.通过 SQL,您如何在表 Persons 中选择 FirstName 等于 Thomas 而 LastName 等于 Carter 的所有记录?您的回答:SELECT * FROM Persons WHERE FirstName='Thomas' AND LastName='Carter'12.通过 SQL,您如何按字母顺序选取 Persons 表中 LastName 介于 Adams 和 Carter 的所有记录?您的回答:SELECT * FROM Persons WHERE LastName BETWEEN 'Adams' AND 'Carter'13.哪条 SQL 语句可返回唯一不同的值?您的回答:SELECT DISTINCT14.哪个 SQL 关键词用于对结果集进行排序?您的回答:ORDER BY15.通过 SQL,您如何根据 "FirstName" 列降序地从 "Persons" 表返回所有记录?您的回答:SELECT * FROM Persons ORDER BY FirstName DESC16.通过 SQL,您如何向 "Persons" 表插入新的记录?您的回答:INSERT INTO Persons VALUES ('Jimmy', 'Jackson')17.通过 SQL,您如何向 "Persons" 表中的 "LastName" 列插入 "Wilson" ?您的回答:INSERT INTO Persons (LastName) VALUES ('Wilson')18.您如何把 "Persons" 表中 "LastName" 列的 "Gates" 改为 "Wilson" ?您的回答:UPDATE Persons SET LastName='Wilson' WHERE LastName='Gates'19.通过 SQL,您如何在 "Persons" 表中删除 "FirstName" 等于 "Fred" 的纪录?您的回答:DELETE FROM Persons WHERE FirstName = 'Fred'20.通过 SQL,您如何返回 "Persons" 表中记录的数目?您的回答:SELECT COUNT(*) FROM Persons
阅读全文
1 0
- Leetcode: Employees Earning More Than Their Managers
- leetcode: Employees Earning More Than Their Managers
- 【Leetcode】Employees Earning More Than Their Managers
- 181. Employees Earning More Than Their Managers
- 181. Employees Earning More Than Their Managers
- 181. Employees Earning More Than Their Managers
- 181. Employees Earning More Than Their Managers
- 181. Employees Earning More Than Their Managers
- 181. Employees Earning More Than Their Managers
- 181. Employees Earning More Than Their Managers
- LeetCode:181. Employees Earning More Than Their Managers
- LeetCode--181. Employees Earning More Than Their Managers
- leetcode 181. Employees Earning More Than Their Managers
- leetcode.181. Employees Earning More Than Their Managers
- [leetcode] 181. Employees Earning More Than Their Managers
- 【leetcode Database】181. Employees Earning More Than Their Managers
- leetcode 181. Employees Earning More Than Their Managers
- Leetcode 181. Employees Earning More Than Their Managers
- MVVM模式下的Visiblox Chart使用
- 常用排序算法
- 《富爸爸穷爸爸》书摘-不要为钱而工作
- [P1281]书的复制[DP]
- 移动web前端小结(一)
- leetcode 181. Employees Earning More Than Their Managers
- 基于Homebrew和easy_install在Mac上搭建Python开发环境
- Systemd 入门教程:实战篇
- java读取文件内容的方法总结
- angular指令:实现复制到剪贴板功能
- 《软件随想录-Joel on Software》书摘
- 隐藏表单 radio的圈圈,用label代替按钮(加上bootstrap或其它修改样式达到美观)
- 基于Spring Mvc实现的Excel文件上传下载
- 完全数据库脱机备份+完全数据库脱机备份案列