请问该如何将ORACLE rownum rn语句转换为Mysql limit语句？

Question

SELECTLONGITUDE,OBLIGATEFROM(SELECTA.*, ROWNUM RNFROM(SELECT*FROMVSOS3WHEREDATE_TIME >= '"+endTime+" 00:00:00'AND DATE_TIME <= '"+startTime+" 23:59:59'AND SITE_NUM = '"+site+"'ORDER BYDATE_TIME DESC) AWHEREROWNUM <= "+(start + limit)+")WHERERN >= "+ (start)+"谁帮我把这句话修改为mysql的limit格式 感激不尽。

Answer 1

SELECTLONGITUDE,OBLIGATEFROMVSOS3WHEREDATE_TIME >= '"+endTime+" 00:00:00'AND DATE_TIME <= '"+startTime+" 23:59:59'AND SITE_NUM = '"+site+"'ORDER BYDATE_TIME DESCLIMIT "+ start +" , "+ limit +"