SELECT id,`影片简介`,`图片名`,`影片名称` FROM DAT_TABLE WHERE `影片类别`=2 and id not in (select id from DAT_TABLE ORDER BY id DESC LIMIT 10) ORDER BY id DESC LIMIT 5 ->SELECT top 5 id,[影片简介],[图片名],[影片名称] FROM [DAT_TABLE] WHERE [影片类别]=2 and id not in (select top 10 id from DAT_TABLE ORDER BY id DESC) ORDER BY id DESC
MYSQL4。0以下可不支持子查询。
正解!
返回第10~15条
下面显示分类的top 5 就不能包括上面top 10的东西了
从11到15