怎么取出数据库中ID号最大的一行记录呢？

[wenejiang]

怎么取出数据库中ID号最大的一行记录呢？ID号是一字段

[j9988]

select top 1 * from tab order by id desc

[zqllyh]

select top 1 * from table order by id desc

[zqllyh]

慢了。

[wenejiang]

select top 1 fld1,fld2 from table order by ID desc
散分了，up 有分

[wenejiang]

我刚给出答案，居然前面有这么多答案了，谢谢各位，再过10分钟就散分了

[pengdali]

select top 1 fld1,fld2 from table order by ID desc

哈哈。。up一下

[j9988]

select * from table where id in (select max(id) from table)

select a.* from table a,(select max(id) as id from table) b where a.id=b.id