-- 2005
select * from
(
select A.*,B.ANAME,B.Address,row_number() over(partition by B.BID order by A.AID) rownum
from A,B where A.BID = B.BID
)T
where rownum <=4
order by A.AID
select * from
(
select A.*,B.ANAME,B.Address,row_number() over(partition by B.BID order by A.AID) rownum
from A,B where A.BID = B.BID
)T
where rownum <=4
order by A.AID
等我有分了 一定加倍给你
还有 你这段代码在2000的数据库里面怎么报没有row_number函数的错啊 ???