常用sql总结

1、分页sql：

SELECT *
          FROM (SELECT A.*, ROWNUM RN
            FROM (SELECT SQID, GSMC, YXQ, FWCS, BDIP
                    FROM T_GRANT_INFO
                   WHERE 1 = 1) A
           WHERE ROWNUM <= 10)
         WHERE RN >= 1

2、将字段值(DMLB)重复查询出来：

SELECT DMLB, COUNT(1) FROM T_SYS_CODE GROUP BY DMLB HAVING COUNT(1) >= 2