猿问

MySQL不支持top关键字,怎么使用limit关键字替代?

"select top "+pageSize+" * from tbl_FWXX f where f.fwid not in "+"(select top "+currPage+" D.fwid from tbl_FWXX D order by D.fwid ) order by f.fwid"这个语句怎么用limit改啊?

holdtom
浏览 930回答 1
1回答
随时随地看视频慕课网APP

相关分类

MySQL
我要回答