将二张表的查询结果进行分页

将2张表的查询结果进行分页

SQL code

select top 2 * from (select * from actor,movie where actor.aid=movie.mid) c where c.id not in(select top 2 id from c) 

Java code

select top 2 * from (select * from actor,movie where actor.aid=movie.mid )T1 where id not in     (select top 2 id       from       (select * from actor,movie where actor.aid=movie.mid )T2      )