力扣
小猴子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 · 166 阅读 · 0 评论 -
力扣数据库 - 182.查找重复的电子邮箱
SQL架构 Create table If Not Exists Person (Id int, Email varchar(255)) Truncate table Person insert into Person (Id, Email) values ('1', 'a@b.com') insert into Person (Id, Email) values ('2', 'c@d.com')...原创 2019-08-30 15:30:38 · 359 阅读 · 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 · 244 阅读 · 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 · 214 阅读 · 0 评论