【SQL分页问题】点击下一页的时候查询不对

C# code

 string strsql = "select top "                           + NUMCount + " * from tb_Student where  ID not in ( select top "                           + number + " ID from tb_Student where fengcai=" + num + "  order by ID desc )and fengcai=" + num + " and email='" + shengfen + "' order by ID desc";

[解决办法]
外层多了 and email='" + shengfen + "'