FROM meter_readings)) - Readings.reading AS Consumption Min(consumption) AS Reading GROUP BY Date(readdate)) AS Readings (SELECT Date(readdate) AS dte,
@Query("INSERT OR IGNORE INTO ChapterInfo (chapterId, readDate) VALUES (:chapterId, :readDate) UPDATEChapterInfo SET readDate = :readDate WHERE chapterId = :chapterId")当我尝试这样做时,我得到了错误:“查
我在MS SQL Server 2008数据库中有一个表,其中包含这样的作业:01So in my example it would like to get this result (ordered by J\_ReadDate DESC):
J_IDJ_Name J_ReadDate J_I_ID
06 Job2 2011-06-26 01:00:08.103