[GitHub] [shardingsphere] moses-keqi edited a comment on issue #5969: shardingsphere sqlserver not support page

[GitBox <gi...@apache.org>]

moses-keqi edited a comment on issue #5969:
URL: https://github.com/apache/shardingsphere/issues/5969#issuecomment-641729645


   example of case: 
     https://shardingsphere.apache.org/document/legacy/4.x/document/en/features/sharding/use-norms/pagination/  Pagination Sub-query
   
   shardingsphere tables zz_sms_send  Pagination  SQL :
   
   SELECT id,batch_id,template_id,mobile,userid,policy_no,custom,content,sys_code,channel_code,send_type,send_time,sale_channel,channel_id,sms_status,case_name,channel_business_id,channel_return_id,create_time,update_time FROM zz_sms_send WHERE 1=1 AND batch_id = ? order by create_time desc offset 0 rows fetch next 10 rows only
   
   > The SQL you provided are not use pagination, can you provide the pagination SQL?
   
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org