力扣
小猴子3000
啊花和大蕉
展开
-
力扣数据库 - 181.超过经理收入的员工
SQL架构Create table If Not Exists Employee (Id int, Name varchar(255), Salary int, ManagerId int)Truncate table Employeeinsert into Employee (Id, Name, Salary, ManagerId) values ('1', 'Joe', '70000',...原创 2019-08-30 15:09:35 · 167 阅读 · 0 评论 -
力扣数据库 - 182.查找重复的电子邮箱
SQL架构Create table If Not Exists Person (Id int, Email varchar(255))Truncate table Personinsert 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 · 361 阅读 · 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 Customersinsert into Customers (Id, Name) values ('1',...原创 2019-08-30 15:57:40 · 245 阅读 · 0 评论 -
力扣数据库 - 176.第二高的薪水
SQL架构Create table If Not Exists Employee (Id int, Salary int)Truncate table Employeeinsert into Employee (Id, Salary) values ('1', '100')insert into Employee (Id, Salary) values ('2', '200')inser...原创 2019-08-31 17:12:38 · 215 阅读 · 0 评论