select * from
(
select * from 表名 order by ＂时间＂ DESC
) where rownum=1;
select top 1 * from tb where 时间=指定时间 order by 时间
selec top 1 from table order by table.datefield asc
distinct
selec top 1 a.* from table a order by a.date1 desc
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024