sql过滤查询结果？

Question

查询的结果是
KID(主键)    FID(外键)      Ncontent(内容)       SubDate(提交时间)
1             1                  A                2009-02-01 08:10:00
2             1                  B                2009-02-01 08:11:00
3             2                  C                2009-02-01 08:12:00
4             3                  D                2009-02-01 08:13:00
5             2                  E                2009-02-01 08:14:00
6             3                  F                2009-02-01 08:15:00怎么把以下结果过滤出来？谢谢
2             1                  B                2009-02-01 08:11:00
5             2                  E                2009-02-01 08:14:00
6             3                  F                2009-02-01 08:15:00

Answer 1

SELECT * FROM TB T WHERE KID=(SELECT MAX(KID) FROM TB WHERE FID=T.FID)

Answer 2

谢谢啊！csdn太牛氓了，我结贴不让我接。

Answer 3

select
  *
from
  tb t
where
  not exists(select 1 from tb where fid=t.fid and kid>t.kid)

Answer 4

select * from TB T where not exists (select * from TB where T.FID=FID And SubDate>T.SubDate )