使用了窗口函数后查询出现问题

WITH RankedData AS (
  SELECT
    __name,
    __activeTime,
    STATE,
    QTY,
    UQTY,
    ROW_NUMBER() OVER (PARTITION BY __name ORDER BY __activeTime DESC) AS rn
  FROM
    ODS_D_DATA_ACQUISITION_YIBU
  WHERE
    STATE != 0
    AND __name = 'DNSB0892-1'
) SELECT
  *
FROM
  RankedData
WHERE
  rn <= 100

底下的where不写或者写rn > 什么的都可以查询，但是用小于或者等于都差不到