题目解析
小猴子3000
啊花和大蕉
展开
-
力扣数据库 - 181.超过经理收入的员工
SQL架构 Create table If Not Exists Employee (Id int, Name varchar(255), Salary int, ManagerId int) Truncate table Employee insert into Employee (Id, Name, Salary, ManagerId) values ('1', 'Joe', '70000',...原创 2019-08-30 15:09:35 · 125 阅读 · 0 评论 -
力扣数据库 - 182.查找重复的电子邮箱
SQL架构 Create table If Not Exists Person (Id int, Email varchar(255)) Truncate table Person insert into Person (Id, Email) values ('1', '[email protected]') insert into Person (Id, Email) values ('2', '[email protected]')...原创 2019-08-30 15:30:38 · 303 阅读 · 0 评论 -
力扣数据库 - 183.从不订购的客户
SQL架构 Create table If Not Exists Customers (Id int, Name varchar(255)) Create table If Not Exists Orders (Id int, CustomerId int) Truncate table Customers insert into Customers (Id, Name) values ('1',...原创 2019-08-30 15:57:40 · 177 阅读 · 0 评论 -
力扣数据库 - 176.第二高的薪水
SQL架构 Create table If Not Exists Employee (Id int, Salary int) Truncate table Employee insert into Employee (Id, Salary) values ('1', '100') insert into Employee (Id, Salary) values ('2', '200') inser...原创 2019-08-31 17:12:38 · 191 阅读 · 0 评论