"SELECT * FROM (" +
" SELECT productid,productname,productnote,productprice,productamount,ROWNUM rn " +
" FROM product WHERE (productid LIKE ? OR productname LIKE ? OR productnote LIKE ? OR productprice LIKE ? OR productamount LIKE ? ) AND " +
" ROWNUM<=? ORDER BY productid) temp " +
" WHERE temp.rn>? " ;
请用mysql支持的方法重写上面的Oracle支持的sql语句.关键就是ROWNUM这里.
婷婷同学_
芜湖不芜
相关分类