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格式 感激不盡。
1 回答
斯蒂芬大帝
TA貢獻1827條經驗 獲得超8個贊
SELECTLONGITUDE,OBLIGATEFROMVSOS3WHEREDATE_TIME >= '"+endTime+" 00:00:00'AND DATE_TIME <= '"+startTime+" 23:59:59'AND SITE_NUM = '"+site+"'ORDER BYDATE_TIME DESCLIMIT "+ start +" , "+ limit +"
添加回答
舉報
0/150
提交
取消