有关max()的小问题 select * from t where id in (select max(id) from t1 group by object) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select TOP 1 id,object,value,col4,clo5from tORDER by id desc select * from t as A, (select object, max(id) as id from t group by object) as B where A.id = B.id and A.object = B.object 这样试验以下?select * from (select object, max(id) as id from t group by object) as B,t as A where A.id = B.id and A.object = B.object 更正:速度是一样的,数据也不少,我的用了distinct select B.* from (select object,max(ID) as ID from t group by object) as B inner join t as A on B.ID = A.ID因为ID为主键。 关于select column_xxx into tabel_xxxx生成表的问题 求简单合并sql top 1 返回值赋给变量怎么做 关于数据的导入导出! 请教一条update的语句 关于数据库中的TIMESTAMP类型 求助。GROUP BY在access中的正确用法。access版无人解答。 我想用在程序里用代码生成数据库的脚本,还有在程序里用代码还原?我应该怎么写?谢谢! 自动导入数据问题 to:icevi(按钮工厂),因为不能在一个帖里头回复超过30次,所以另开一贴。我的解决方法: 急!!!一个sql问题! 各位看一看吧!
from t
ORDER by id desc
where A.id = B.id and A.object = B.object
where A.id = B.id and A.object = B.object
from (select object,max(ID) as ID from t group by object) as B inner join t as A
on B.ID = A.ID因为ID为主键。