String sql ="select top 5 * from news " +
"where n_id not in(select top "+rowBegin+" n_id from news order by n_id) " +
"order by n_id";错误提示:未找到要求的FROM关键字!大家帮我想想办法!谢谢
"where n_id not in(select top "+rowBegin+" n_id from news order by n_id) " +
"order by n_id";错误提示:未找到要求的FROM关键字!大家帮我想想办法!谢谢
-oracle没有top,mssql才有的,下面这种写法要把你需要的列全写了
String sql ="select 你的列 from ( " +
"select row_number() over(order by n_id) rn,你的列 from news " +
" where rn between "+(Convert.ToInt32(rowBegin)+1).ToString()+
" and "+(Convert.ToInt32(rowBegin)+5).ToString();
--你也可以这样写,下面是取6-10条记录
select * from emp where rownum<11
minus
select * from emp where rownum<6;