select num from table where cast(DateFaSheng as char(10))+ MaterCode in (select cast(max(DateFaSheng) as char(10))+ MaterCode from table group by DateFaSheng,MaterCode)
解决方案 »
- SQL2005的CD2~谁有啊,郁闷死了
- 如何把重复的记录删除?
- 高分請求大師:關於簡體,繁體存入SQL內是處理為Unicode(UTF-8)類形 50分急急!!!!
- 两个触发器
- SQL中的导入和导出的问题!
- 自定义函数
- 为什么sqlserver.exe占用600多M的内存?
- 多个数据库同时查询统计
- 这里没有人关心Yokun吗?还是大家都在闭门造车?
- 救命啊!!!!!!!!!!!!! 这个 sql 语句怎么写??? 哪位高手知道???? >>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>>
- 高手请进
- 关于SQL中varchar转换成money各位大侠帮小弟一把~ 在线等
insert t select 3,'2007-04-25','120101001'
union all select 8,'2007-04-27','120101001'
union all select 13,'2007-05-01','120101001'
union all select 8,'2007-05-06','124301001'
union all select 8,'2007-05-12','124301001'select * from t a where not exists
(
select 1 from t where MaterCode=a.MaterCode and DateFaSheng>a.DateFaSheng
)Num DateFaSheng MaterCode
----------- ------------------------------------------------------ ------------------
13 2007-05-01 00:00:00.000 120101001
8 2007-05-12 00:00:00.000 124301001(所影响的行数为 2 行)