一个特殊的SQL语句

[xiaomangxian]

我有一个数据库，里面有几个表，分别是

A表

aid atitle ashow

C表

cid aid ctitle ctime


读取C表前10条数据，并且这十条数据中，aid是不一样的，请问该怎么写呢？

[zzxap]

select top 10 cid, aid , ctitle, ctime from table a where exists (select top 1 aid from table where aid=a.aid )

[hoojo]

如果是查A表：

select  distinct top 10 cid,  aid , ctitle, ctime  from  a order by aid

试试看吧
^_@

[wuyq11]

SELECT * FROM table1 WHERE cid IN (SELECT TOP 10 from table1 GROUP BY aid)

[pt1314917]

select top 10 * from c a
where not exists(select 1 from c where aid=a.aid and cid<a.cid)
order by cid

[Laura_li]

select top 10 from c group by aid
或者
select distinct top 10 from c

[xiaomangxian]

貌似都不行啊