with t as (select *,ROW_NUMBER() over(order by first_name)as ranking from employees order by emp_no) select t.first_name from t where power(-1,ranking)<0核心在于排个序
with t as (select *,ROW_NUMBER() over(order by first_name)as ranking from employees order by emp_no) select t.first_name from t where power(-1,ranking)<0核心在于排个序
牛客博客，记录你的成长
京公网安备 11010502036488号