string sql = "select top {0} * from StudentInfo where StudentInfoId not in (select top {1} StudentInfoId from StudentInfo order by StudentInfoId desc) order by StudentInfoId desc";
...全文
437打赏收藏
帮帮忙,sql语句看不懂了!!!!
string sql = "select top {0} * from StudentInfo where StudentInfoId not in (select top {1} StudentInfoId from StudentInfo order by StudentInfoId desc) order by StudentInfoId desc";
select top 5 * from StudentInfo where StudentInfoId
not in (select top 10 StudentInfoId from StudentInfo order by StudentInfoId desc) order by StudentInfoId desc