27,582
社区成员
发帖
与我相关
我的任务
分享如何查得最大行
有表tab1,字段(id,time1,time2)
080700080 2008-07-28 00:00:00.000 2008-07-31 00:00:00.000
080700080 2008-07-28 00:00:00.000 2008-08-28 00:00:00.000
080700081 2008-07-28 00:00:00.000 2008-07-31 00:00:00.000
080700080 2008-07-28 00:00:00.000 2008-08-11 00:00:00.000
080700081 2008-07-28 00:00:00.000 2008-09-31 00:00:00.000
要取得结果:
080700080 2008-07-28 00:00:00.000 2008-08-28 00:00:00.000
080700081 2008-07-28 00:00:00.000 2008-09-31 00:00:00.000
如何查询？？？
...全文
请发表友善的回复…
发表回复
-晴天 2008-07-28
- 打赏
- 举报
select id,time1,max(time2) from tab1 group by id,time1
ojuju10 2008-07-28
- 打赏
- 举报
select * from tab1 t
where t.time2 in (select max(time2) from tab1 where id= t.id and time1 =t.time1 )
where t.time2 in (select max(time2) from tab1 where id= t.id and time1 =t.time1 )
hery2002 2008-07-28
- 打赏
- 举报
select * from tab1 t
where not exists(select 1 from tab1 where id= t.id and time1 =t.time1 and time2>t.time1)
