题解 | #给出employees表中排名为奇数行#
给出employees表中排名为奇数行的first_name
https://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
with tmp as(
select *, row_number() over(order by first_name asc) as r from employees
)
select e.first_name from employees e inner join tmp t on e.first_name = t.first_name where t.r % 2 = 1
IF就是WHERE, SQL 的where相当于C++ PY JAVA的IF，
投递360集团等公司10个岗位