即对应于sql server的下列语句怎么改写到sybase中适用?
select top 20 * from Products
where ( ProductID not in
( select top 10 ProductID from Products
where (ProductID > 3 and ProductID< 200) order by ProductID) )
and (ProductID > 3 and ProductID< 200)
order by ProductID
select top 20 * from Products
where ( ProductID not in
( select top 10 ProductID from Products
where (ProductID > 3 and ProductID< 200) order by ProductID) )
and (ProductID > 3 and ProductID< 200)
order by ProductID
该语句能在Sybase中用吗?ps:Sybase人气太低,借MSSQL问问
然后在这个临时表中根据这个id来找出所要的数据段不知道上述过程怎么用sql语言实现?