Question

sql server表里面有个“时间”字段，按照时间段查出最新数据，而且有多条记录，只显示一条？请高手指点

Answer 1

select * from
(
select * from 表名　order by ＂时间＂　DESC
) where rownum=1;

Answer 2

select top 1 * from tb where 时间=指定时间 order by 时间

Answer 3

selec top 1 from table order by table.datefield asc

Answer 4

distinct

Answer 5

selec top 1 a.* from table a order by a.date1 desc