select top 1 * from T_ClientConsuemLog order by F_ClientConsumeMon desc ,F_ClientConsumeDate desc;追问
肯定不对
第2个回答 2012-07-12
oracle
select F_ClientConsumeID,F_ClientID,F_ClientConsumeDate,F_ClientConsumeMon from ( select F_ClientConsumeID,F_ClientID,F_ClientConsumeDate,F_ClientConsumeMon, row_number() over(partition F_ClientConsumeID order by F_ClientConsumeDat desc) "row" ) where "row"=1
第3个回答 2012-07-12
select count(* ) from T_ClientConsuemLog select * from T_ClientConsuemLog group by F_ClientConsumeID -- 不知道那个字段代表 人追问
是同一个F_ClientID有很多条把? select * from T_ClientConsuemLog,( select max(F_ClientConsumeID) as fid from T_ClientConsuemLog group by F_ClientID) tablea where T_ClientConsuemLog. F_ClientConsumeID = tablea.fid本回答被提问者和网友采纳