表格如下:
id num time
01 202 9:01
01 182 9:05
01 122 9:09
03 102 9:11
03 282 9:25
04 422 9:39
... ... ....
求:
各个id在不超过某个时刻(9:03) 最后一条记录?
如:
id num
01 182
03 102
04 422
id num time
01 202 9:01
01 182 9:05
01 122 9:09
03 102 9:11
03 282 9:25
04 422 9:39
... ... ....
求:
各个id在不超过某个时刻(9:03) 最后一条记录?
如:
id num
01 182
03 102
04 422
--將就寫一下
select A.id,A.num from T A
inner join
(select id,min(time) as time from T where time>='9:03' group by id) B
on A.id=B.id and A.time=B.time
where time >= '9:03' and
not exists (select 1 from tablename where id = t1.id and num > t1.num and time >='9:03' )