Leetcode之PHP版题目解析（215. Kth Largest Element in an Array）

/**

     * @param Integer[] $nums

     * @param Integer $k

     * @return Integer

     */

    function findKthLargest($nums, $k) {

        sort($nums);

        $count=count($nums);

        return $nums[$count-$k];

    }

select d.name as Department ,e.Name as Employee ,e.Salary as Salary from Department d,Employee e,

(select DepartmentId,Max(Salary)Salary from Employee GROUP BY DepartmentId) m  where e.DepartmentId = d.Id 

and e.DepartmentId=m.DepartmentId

and e.Salary=m.Salary