cid | uid | title |ctime...
12 | 134 | abc |2007-06-06
13 | 102 | def |2007-06-06
12 | 102 | def |2007-06-06
13 | 102 | def |2007-06-06
15 | 102 | def |2007-06-06
15 | 102 | def |2007-06-06
13 | 102 | def |2007-06-06
.. ... ..
要求
按时间顺序 每个公司id(cid)只取一条记录（所有字段）取top N条记录
请sql高手帮忙 谢谢 啦
------解决方案--------------------
Select Top N cid,uid,title,ctime From [YourTable] Group By cid Order By ctime Desc
这样只能做到选择N个记录，不能做到每公司一条
你这样有点复杂的需要用存储过程
------解决方案--------------------
呵呵,忘排队了:
select cid,uid,title,time from(
select cid,uid,title,max(ctime) time from yourtable group by cid,uid,title
) where rownum < N order by time desc
------解决方案--------------------
楼上的不用加order by time desc
已经用max(ctime)了
强烈怀疑楼上的楼上是否能达到一公司一记录的要求
------解决方案--------------------
select top N * from article order by ctime DESC
------解决方案--------------------
select * from food_comment where ctime in(SELECT max(ctime) as t FROM food_comment GROUP BY cid)
按时间顺序 每个公司id(cid)只取一条记录（所有字段）取top N条记录
-----------------------------------------------
这条SQL跟你文字表述的意图一致么？
------解决方案--------------------
select top N * from TABLE as A where A.cid in (select top 1 cid from TABLE as B where B.cid=A.cid) order ty ctime