这样的查询怎么写？上次别人回的结了贴才发现不行的。没分了，请原谅

[stevegates]

有一个表有若干字段，其中一个字段topic有ST,SL,CM三个值，另一个date字段。
我希望得到每个topic相同的纪录中date最大的前三条（一共九条），怎么写？

谢谢。

[pengdali]

select * from 表 tem where date in (select top 3 date from 表 where topid=tem.topid order by date desc)

[stevegates]

感谢，能不能告诉我 tem是什么？

[lynx1111]

1.
select * from topic tem where time in (select top 3 time from topic where topic=tem.topic order by time desc)order by topic

2.
select * from topic a where (select count(*) from topic b where a.topic=b.topic and b.TIME<=a.TIME)<=3 ORDER BY topic

[CrazyFor]

select * from 表 a where (select count(*) from 表 b where a.topic=b.topic and b.date字段>=a.date字段)<=3

[yujohny]

//感谢，能不能告诉我 tem是什么？

tem是给你“表”定义的别名

[Ianlan]

用union all可以实现的

[stevegates]

感谢大家.