请问，一个排序问题！

[aivii]

下面的语句，我已经排好序了（这是我在ACCESS中调试的，可能与SQL有出入):

select * from product where int(lb_id)=int("&lbid&") and ltrim(rtrim(key5))<>'' order by int(right(ltrim(rtrim(key5)),len(key5)-1))

但我想在此基础上，找出记录id(自增量)号为:100的下面三条记录，
请问大侠们，得如何写啊？谢谢！

[futulove]

自增号为101，102，103的吗
id=不就可以了吗

[huwgao]

select top 3 *
from product
where int(lb_id)=int("&lbid&")
and ltrim(rtrim(key5))<>''
and int(right(ltrim(rtrim(key5)),len(key5)-1))>
(select int(right(ltrim(rtrim(key5)),len(key5)-1))
from product
where id=100)
order by int(right(ltrim(rtrim(key5)),len(key5)-1))

[梅青松]

select * from product where int(lb_id)=int("&lbid&") and ltrim(rtrim(key5))<>'' order by int(right(ltrim(rtrim(key5)),len(key5)-1)) and rownum < 4 and id > 100

[CSDMN]

top 3
?
不是很明白楼主要什么

[victorycyz]

select top 3 *
from product
where int(lb_id)=int("&lbid&") and ltrim(rtrim(key5))<>'' and id>100
order by id

[aivii]

可能没懂我的意思，
我是想能通过一句SQL语句实现取ID为100的下面三样记录，
在
select * from product where int(lb_id)=int("&lbid&") and ltrim(rtrim(key5))<>'' order by int(right(ltrim(rtrim(key5)),len(key5)-1))
的基础，
也就是融为成一条语句，达到此目的，还请指点！
谢谢！