select * from (select ROW_NUMBER() OVER(ORDER BY id asc)
AS ROWNUM, id,source_addr,destination_addr,short_message,create_time,send_time,status,client_name,remark,message_ref_id,count,result,parent_id,current_addr,sequence_no from sms_sm_activity ) a
where ROWNUM > ${beginSize} and ROWNUM <=${endSize}
AS ROWNUM, id,source_addr,destination_addr,short_message,create_time,send_time,status,client_name,remark,message_ref_id,count,result,parent_id,current_addr,sequence_no from sms_sm_activity ) a
where ROWNUM > ${beginSize} and ROWNUM <=${endSize}