即以上数据我只要前5条的记录筛选出来,不要第六条的
[/Quote]
SELECT *,RECNO() as px FROM aa INTO CURSOR dd
SELECT * FROM dd a;
inner join ;
(SELE top 5 px FROM dd WHER 'B'$dd order by 1) b;
ON a.px=b.px;
如果固定的话:
SELECT *,RECNO() as px FROM aa INTO CURSOR dd
SELECT * FROM dd a;
inner join ;
(select top 4 px FROM (SELE top 5 px FROM dd WHER 'B'$dd order by 1 desc) c ORDER BY px desc)b;
ON a.px=b.px;