chenxi6761的博客

###先对每个公司员工工资排序并增加一列序号，然后计算每个公司人数，把两部分join起来取每个公司序号为该公司（总数+1）/2的数据 select a.Id, a.Company, a.Salary from( select a., @num:=if(@company=Company, @num+1, 1) as num, @company:=Company from Employee as a,...

select b.name as Department, a.name as Employee, a.Salary from( select a.*, @rank:=case when @department=DepartmentId and @salary<>salary then @rank+1 when @department...

Employee表中有一年的员工薪资信息，写一个sql来获得3个月内员工工资的累计总和，但不包括最近一个月 方法一，待验证 select a.Id,a.Month, sum(Salary) as cu_salary from Employee as a join Employee as b on a.Id=b.Id and a.Month<=b.Month join( select Id...

##方法一 select Department, Employee, Salary from( select a.*, @rank:=case when @id=Department and @money<>Salary then @rank+1 when @id=Department and @money=Salary then ...

select id, visit_date, people from( select a.*, @j:=if(@num2>=100 and people>=100, @j, @j+1) as orders, @num2:=people as peo from stadium as a, (select @num2:=0, @j:=0) as b ) as a whe...