SELECT TOP 分页数 *
FROM theme
WHERE (theme_id NOT IN
SELECT TOP (分页数*当页) theme_id "
FROM theme
ORDER BY theme_id DESC))
ORDER BY theme_id DESC能够成功分页可有个问题,我怎么得到表里一共有多少数据?
怎么知道一共能分几页?新手分不多..不好意思.
FROM theme
WHERE (theme_id NOT IN
SELECT TOP (分页数*当页) theme_id "
FROM theme
ORDER BY theme_id DESC))
ORDER BY theme_id DESC能够成功分页可有个问题,我怎么得到表里一共有多少数据?
怎么知道一共能分几页?新手分不多..不好意思.
然后再: (总记录数+每面显示条数)/每面显示的条数=分页数