题解 | #对于employees表中，给出奇数行的first_name#
对于employees表中，给出奇数行的first_name
http://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
SELECT e1.first_name
FROM employees e1
WHERE (
SELECT count(*)
FROM employees e2
WHERE e1.first_name >=e2.first_name
)%2=1;
方法2：
SELECT b.first_name
FROM employees AS b,(
SELECT first_name,DENSE_RANK() OVER(ORDER BY first_name) AS t_rank
FROM employees
) AS a
WHERE b.first_name=a.first_name AND a.t_rank%2=1
传音控股公司福利 356人发布
查看14道真题和解析