SET @ROWNUM=0;
SELECT CUST.* FROM
(SELECT @ROWNUM:=@ROWNUM+1 AS RN, BECR_ID,BECR_CODE,BECR_NAME,BECR_TYPE,NATU_IDCARD,CORP_ORAGNIZATION_CODE FROM
T_BASE_CUSTOMER WHERE @ROWNUM<10 ) CUST
WHERE CUST.RN>= 1
SET @ROWNUM=0;
SELECT CUST.* FROM
(SELECT @ROWNUM:=@ROWNUM+1 AS RN, BECR_ID,BECR_CODE,BECR_NAME,BECR_TYPE,NATU_IDCARD,CORP_ORAGNIZATION_CODE FROM
T_BASE_CUSTOMER WHERE @ROWNUM<10 ) CUST
WHERE CUST.RN>= 1