题解 | 给出employees表中排名为奇数行的first_name
给出employees表中排名为奇数行的first_name
https://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
-- 首先必须求出排名
WITH ranking_employees AS(
SELECT *,RANK() OVER(order by first_name) ranking
FROM employees
)
-- 找出排名为奇数
SELECT first_name
FROM employees
WHERE first_name IN(
SELECT first_name
FROM ranking_employees
WHERE ranking % 2=1
)
查看7道真题和解析