sql - 显示最后一名被录用的员工(show the last employee who was hired)

Question

I need to find most recent hired employees for example i have table

(我需要找到最近雇用的员工，例如我有桌子)

INPUT

(输入)

------------------------
|   name  |  hire_date |
------------------------
| Michael | 11-JAN-2010|
| Eugene  | 20-DEC-2018|
------------------------

Need to add third column with '*' in one line with last hired employeer

(需要与最后雇用的雇员在一行中添加带有“ *”的第三列)

OUTPUT

(输出值)

----------------------------------
|   name  |  hire_date | maxdate |
----------------------------------
| Michael | 11-JAN-2010|         |
| Eugene  | 20-DEC-2018|    *    |
----------------------------------

  ask by Женя Касьян translate from so

Answer 1

In the most recent version of Oracle, use order by and fetch :

(在Oracle的最新版本中，使用order by和fetch ：)

select e.*
from employees e
order by hire_date desc
fetch first 1 row only;

In earlier versions, this is often implemented using a subquery:

(在早期版本中，通常使用子查询来实现：)

select e.*
from (select e.*
      from employees e
      order by hire_date desc
    ) 
where rownum = 1;

Both of these return only one row -- your question is in the singular.

(两者都只返回一行-您的问题是单数形式。)

There are variations that return all the most recent employees if there are duplicates.

(如果有重复，有一些变体会返回所有最近的雇员。)