牛客962116116号

分类

题解(2)

/ 注册

全部文章（共1篇）

题解 | #对于employees表中，给出奇数行的first_name#

SELECT first_name FROM employees WHERE emp_no IN (SELECT emp_no FROM( SELECT emp_no,ROW_NUMBER() OVER( ORDER BY first_name ASC) AS r_num FROM employee...

Sqlite

2021-09-17

0 377