SELECT
e1.first_name
FROM
employees e1
WHERE
( SELECT count(*) FROM employees e2 WHERE e1.first_name >= e2.first_name )% 2 = 1
牛客SQL练习-61-对于employees表中,输出first_name排名(按first_name升序排序)为奇数的first_name
最新推荐文章于 2021-08-29 19:50:12 发布
SELECT
e1.first_name
FROM
employees e1
WHERE
( SELECT count(*) FROM employees e2 WHERE e1.first_name >= e2.first_name )% 2 = 1