摘要:
select count(*) from Report;sql server中不支持limit操作,但是可以用top;如下:[sql]view plaincopyselectidfromtablename如果要查询上述结果中前6条记录,则相应的SQL语句是:[sql]view plaincopyselecttop6idfromtablename如果要查询上述结果中第 7 条到第 9 条记录,则相应的SQL语句是:[sql]view plaincopyselecttop3idfromtablenamewhereidnotin(selecttop6idfromtablename)[sql]view 阅读全文