1、...where Bigclassname='名一佳教'就行了。2、select top 10 * from newswhere Bigclassname='名一佳教' and Bigclassname not in(select top 1 Bigclassname from news where Bigclassname='名一佳教')。可能有点复杂,期待简化的...
1. sql="select top 1 * from news where Bigclassname='名一佳教'"2. sql="select top 9 * from (select top 10 * from news where Bigclassname='名一佳教' order by id desc) order by id desc"3...