yezizp的专栏

简单连接统计~~select d.Name as Department,ee.Name as Emplyee,ee.Salary as Salaryfrom Department d,( select * from Employee e where (select count(distinct Salary) from Employee where

用用户变量记录出现次数即可~select distinct NUM from( select NUM, @count := if(@prevNum = NUM, @count + 1, 1) as cnt, @prevNum := NUM from Logs, (select @prevNum := NULL) pn, (select @count := 0) ct o