零分的博客

select Score,(select count(distinct score) from scores where score>=t1.Score ) as Rank from scores t1 order by t1.score desc另外在mysql中 好像是没有dense_rank()等函数的

参考评论区解答：delete t1 from person t1,person t2 where t1.email=t2.email and t1.id>t2.id

select u0.FirstName,u0.LastName,u1.City,u1.State from person as u0 left join address as u1 on u0.personid=u1.personid

update salary set sex=if(sex='f','m','f')评论区一种惊奇解法：update salary set sex = char(ascii('m') + ascii('f') - ascii(sex));

常规解法：select u0.name as Employee from Employee u0 where salary >(select u1.salary from employee u1 where u1.id=u0.managerid)评论区的一种快解法 用 inner join :select a.name as Employeefrom employee a inner...

select t0.name as Customers from Customers t0 where not exists (select * from orders t1 where t0.id=t1.customerid)高赞解法 左连接： select Name as Customers from Customers left join Orders on Customers.Id...