有些业务需求,我们需要获取排序后的第一条数据,Oracle需要一个子查询来实现.
with t as
(select * from t_table
order by createdTime desc)
select * from t where rownum =1
有些业务需求,我们需要获取排序后的第一条数据,Oracle需要一个子查询来实现.
with t as
(select * from t_table
order by createdTime desc)
select * from t where rownum =1