原数据
K NO Data
Q 082G0003 2008-09-01 06:50:00.000
T 082G0003 2008-09-01 17:10:00.000
Q 082G0004 2008-08-03 22:25:00.000
T 082G0004 2008-08-04 09:50:00.000
Q 082G0032 2008-08-02 20:15:00.000
T 082G0032 2008-08-03 09:40:00.000
Q 082G0033 2008-08-02 20:15:00.000
T 082G0033 2008-08-03 09:40:00.000
T 082G0036 2008-08-03 09:40:00.000
Q 082G0036 2008-08-02 20:15:00.000
Q 082G0021 2008-08-02 20:15:00.000 查询后的数据
K NO Data
T 082G0003 2008-09-01 17:10:00.000
T 082G0004 2008-08-04 09:50:00.000
T 082G0032 2008-08-03 09:40:00.000
T 082G0033 2008-08-03 09:40:00.000
Q 082G0036 2008-08-02 20:15:00.000
Q 082G0021 2008-08-02 20:15:00.000
K NO Data
Q 082G0003 2008-09-01 06:50:00.000
T 082G0003 2008-09-01 17:10:00.000
Q 082G0004 2008-08-03 22:25:00.000
T 082G0004 2008-08-04 09:50:00.000
Q 082G0032 2008-08-02 20:15:00.000
T 082G0032 2008-08-03 09:40:00.000
Q 082G0033 2008-08-02 20:15:00.000
T 082G0033 2008-08-03 09:40:00.000
T 082G0036 2008-08-03 09:40:00.000
Q 082G0036 2008-08-02 20:15:00.000
Q 082G0021 2008-08-02 20:15:00.000 查询后的数据
K NO Data
T 082G0003 2008-09-01 17:10:00.000
T 082G0004 2008-08-04 09:50:00.000
T 082G0032 2008-08-03 09:40:00.000
T 082G0033 2008-08-03 09:40:00.000
Q 082G0036 2008-08-02 20:15:00.000
Q 082G0021 2008-08-02 20:15:00.000
select * from 表名 a where not exists(select 1 from 表名 where no=a.no and data>a.data)
select * fromt where date in (select max(date) from table group by no)
Q 082G0036 2008-08-02 20:15:00.000 ->
Q 082G0036 2008-08-02 20:15:00.000
select K,NO,Data from #t a where not exists(select 1 from #t where NO=a.NO and idno>a.idno ) drop table #t