ronawilliam的专栏

从publish 表中取出第 n 条到第 m 条的记录SELECT TOP m-n+1 * 　　FROM publish　　WHERE (id NOT IN (SELECT TOP n-1 id FROM publish)) 存储过程： CREATE PROCEDURE pagination2 　　(　　@SQL nVARCHAR(4000), --不带排序语句

选课表tSC，学生表tStu，课程表tCou1.求选课人数select tSC.cname ,count(sno) from tSC Group by tSC.cno having count(*)>32.学生成绩表(连接)select tStu.sname,tSC.cname,tSC.score from tStu,tSC where tStu.sid=tSC.sid3.每门