题解 | #给出employees表中排名为奇数行的first_name#
给出employees表中排名为奇数行的first_name
http://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
-- 先排序再选择
select first_name
from employees
where first_name in (
select first_name
from(
select first_name,
dense_rank() over (order by first_name) as dr
from employees ) as t1
where dr%2=1 )
select first_name
from employees
where first_name in (
select first_name
from(
select first_name,
dense_rank() over (order by first_name) as dr
from employees ) as t1
where dr%2=1 )
查看1道真题和解析
腾讯成长空间 6071人发布