去重分页sql语句

---恢复内容开始---

SELECT
    [TAGNAME]
FROM (
        SELECT
            tagname,ROW_NUMBER() OVER(order by tagname) AS RowNumber
        FROM
            (SELECT DISTINCT(tagname) FROM H201402_Hour)
        AS S
        )
        AS T
WHERE RowNumber BETWEEN 1 and 20

---恢复内容结束---