若有自增列:
select top 1 * from table1 order by id desc
若有时间列:
select top 1 * from table1 order by edate desc
若没有任何标志,没有办法!
select top 1 * from table1 order by id desc
若有时间列:
select top 1 * from table1 order by edate desc
若没有任何标志,没有办法!
ORDER BY 排序字段 DESC(从大到小)|ASC(从小到大)主要看你是怎么排序,那条记录是记录集的最后一条记录
select identity(int,1,1) AS id_num,* into #temp from yourtable
select * from #temp where id_num=(select max(id_num) from #temp)