摘要:
1、查询一表中的10-15的记录select top 6 * from (select top 15 * from Users order by UserID ASC) order BY UserID DESC2、查询10-15之间的记录(注意ID不连续)select top3 * from 表 where id not in (select top5 id from 表 )3、使用A、B表造C表看图:A表结构:B表:C表:用到的SQL语句:ALTER VIEW View_Usersasselect b.BID,UserName,Btitle,b.UserID,Btime from Use.. 阅读全文