String sql = " SELECT SERVERITY_DEVICE_ID,DEVICEVENDOR_NAME,SERVERITY_NAME,COLOR,UPDATE_DATE,UPDATE_BY"
                + " FROM ( "
                + " SELECT SERVERITY_DEVICE_ID,DEVICEVENDOR_NAME,SERVERITY_NAME,COLOR,MAPPING_SERVERITY_DEVICE.UPDATE_DATE,MAPPING_SERVERITY_DEVICE.UPDATE_BY,"
                + " ROW_NUMBER() OVER(ORDER BY DEVICEVENDOR_NAME ASC) AS ROWNUM "
                + " FROM MAPPING_SERVERITY_DEVICE "
                + " LEFT JOIN M_DEVICEVENDOR ON MAPPING_SERVERITY_DEVICE.DEVICE_ID  = M_DEVICEVENDOR.DEVICEVENDOR_CODE "
                + " LEFT JOIN M_SERVERITY ON MAPPING_SERVERITY_DEVICE.SERVERITY_ID = M_SERVERITY.SERVERITY_ID "
                + " WHERE SERVERITY_NAME LIKE(?) AND LOWER(DEVICEVENDOR_NAME) LIKE LOWER(?) "
                + " ) AS A ";