亚网互联网站设计,免费标志在线设计,地方建设的钱哪里来,青岛知名网站建设公司排名提示#xff1a;文章写完后#xff0c;目录可以自动生成#xff0c;如何生成可参考右边的帮助文档 文章目录 175. 组合两个表176. 第二高的薪水177. 第N高的薪水178. 分数排名181. 超过经理收入的员工182. 查找重复的电子邮箱183. 从不订购的客户 175. 组合两个表
select p… 提示文章写完后目录可以自动生成如何生成可参考右边的帮助文档 文章目录 175. 组合两个表176. 第二高的薪水177. 第N高的薪水178. 分数排名181. 超过经理收入的员工182. 查找重复的电子邮箱183. 从不订购的客户 175. 组合两个表
select p.FirstName, p.LastName, a.City, a.Statefrom Person p left join Address aon p.personida.personid176. 第二高的薪水
select (select distinct salary from Employee order by salary desc limit 1,1) as SecondHighestSalary177. 第N高的薪水
CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGINset N N-1;RETURN (# Write your MySQL query statement below.select (select distinct salary from Employee order by salary desc limit N,1) as SecondHighestSalary);
END178. 分数排名
SELECT score, DENSE_RANK() OVER (ORDER BY score DESC) AS rank
FROM (SELECT score, ROW_NUMBER() OVER (ORDER BY score DESC) AS rnFROM Scores
) s
ORDER BY rank ASC;181. 超过经理收入的员工
select a.name as Employee from Employee a join Employee b
on a.managerId b.id where a.salary b.salary182. 查找重复的电子邮箱
select distinct a.email Email from Person a left join Person b on a.email b.email where a.id ! b.id183. 从不订购的客户
select a.Name Customers from ( select Name, Orders.Id from Customers left join Orders on Customers.Id Orders.CustomerId ) a where a.Id is nullSELECT Name AS Customers
FROM Customers
WHERE Id NOT IN (SELECT CustomerId FROM Orders);
