求助一表查询! select * from ChangeFeeSet tem where [Time]=(select top 1 [time] from ChangeFeeSet where CardId=tem.CardId) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 取出后的结果的CardId不一样,怎么是取同一CardId的最近的记录 select * from ChangeFeeSet tem where [Time]=(select max([time]) from ChangeFeeSet where CardId=tem.CardId) Try:Select a.* from ChangeFeeSet aJoin(Select CardId,Max(Time) as Time from ChangeFeeSet) bon a.CardId = b.CardId and a.time = b.Time select * from ChangeFeeSet where Time in (select max(Time) from t group by Time) as a select * from ChangeFeeSet where Time in (select max(Time) from ChangeFeeSet group by Time) as a select * from ChangeFeeSet tem where [Time]=(select min([time]) from ChangeFeeSet where CardId=tem.CardId) select * from ChangeFeeSet tmp where not exists (select 1 from ChangeFeeSet wheretmp.[time]<[time] where CardId=tmp.CardId) select * from ChangeFeeSet group by CardID haveing Time=Max(Time) 请问SQL-SERVER如何查询带引号的数据?~谢谢! 两数据库间导入所有表和记录问题 【新手】每次对数据库访问后都要释放资源么? 请教csv文件中有null值如何用bcp导入 在sql_server中如何只取服务器时间?(等待) 怎样让结果集按照一定的顺序排列(不是升序,也不是降序) 为什么连不上 对数据库怎么处理? 能否简化这段SQL? 求个去重复的sql 应该是是很简单的一条SQL语句,但是我不会 表记录无法删除...提示:对象名 'info_type' 无效。
Select a.* from ChangeFeeSet a
Join
(Select CardId,Max(Time) as Time from ChangeFeeSet) b
on a.CardId = b.CardId and a.time = b.Time
ChangeFeeSet where CardId=tem.CardId)
tmp.[time]<[time] where CardId=tmp.CardId)