sql语句的‘ ？’ 参数传不进去。
SELECT top ? * from(
select a.*,ROW_NUMBER() over(order by a.id) as rowno
FROM table1 a,table2 b,table3 c where a.id=b.id and a.id=c.id )tbl
where tbl.rowno>(?*?)
order by tbl.id;
SELECT top ? * from(
select a.*,ROW_NUMBER() over(order by a.id) as rowno
FROM table1 a,table2 b,table3 c where a.id=b.id and a.id=c.id )tbl
where tbl.rowno>(?*?)
order by tbl.id;
