oracle:
select * from (select *,rownum as sn from tablename order by 时间 desc) as t where sn=1
还有:
SELECT * from tablename where 时间=(select max(时间) from tablename)
MySQL:
select top 1 * from tablename order by 时间 desc
oracle: select * from (select *,rownum as sn from tablename order by 时间 desc) as t where sn=1还有:SELECT * from tablename where 时间=(select max(时间) from tablename)MySQL:select top 1 * from tablena...