像这样的记录
uid data time
1 data1 1270211980
1 data2 1270211981
2 data3 1270211983如何取出uid=1的时间最大的记录?
select * from table_name where time = (select MAX(time) from table_name)这样我感觉效率好像不高,有没有更好的办法?
uid data time
1 data1 1270211980
1 data2 1270211981
2 data3 1270211983如何取出uid=1的时间最大的记录?
select * from table_name where time = (select MAX(time) from table_name)这样我感觉效率好像不高,有没有更好的办法?
select top 1 * from table_name where uid = 1 order by time desc
id最快了order by id desc