有关sql语句问题
梦里独赏花 2011-10-14 08:44:19 select * from (SELECT row_number() over(order by c.id)rowNum, c.id,max(D.dvsname)dvsName,max(c.facesn)faceSN,max(b.imagePath)imagePath,max(c.capTime)capTime,max(m.captureid) captureid,max(m.state)state FROM capture AS c INNER JOIN matchlog AS m ON m.captureid=c.id INNER JOIN dvs AS D ON D.id=c.dvsId INNER JOIN bimage AS b ON c.bimageid=b.id WHERE c.capTime >='{0} ' group by c.id) temp WHERE rownum>({1}-1)*{2} AND rownum<={1}*{2} 为什么WHERE c.capTime >='{0} ' 不起作用 整条语句查询的结果是所有的并没有根据where条件进行筛选