Oracle_获取最新一条记录

时间 2019-12-07 标签 oracle 获取最新一条记录

1web

select rownum ,a.* from t_table a  where rownum <100

2svg

SELECT * FROM (
	SELECT *,ROWNUM rn FROM t ORDER BY inputDate DESC
) WHERE rn = 1