SQL语句错误分析及修正 - 缺少<where>标签及表别名 - 常规

{"title":"SELECT T.* \nFROM (\n SELECT A.ID ,\n ROW_NUMBER() OVER(ORDER BY A.CREATE_TIME DESC )ITEM,\n A.YEAR_NO ,\n A.WORK_DATE ,\n A.PLAN_ACHIEVE_RATE ,\n A.CREATE_BY ,\n A.CREATE_TIME ,\n A.EDIT_BY ,\n A.EDIT_TIME \n FROM C_PLAN_ACHIEVE_RATE_T A \n \n A.DEL_FLAG = 0\n <if test= "V_YEAR_NO IS NOT NULL">\n AND YEAR_NO = #{V_YEAR_NO}\n \n \n) T\nWHERE T.ITEM > #{V_PAGE - 1} * #{V_ROWS}\nAND T.ITEM < #{V_PAGE * V_ROWS} 幫我指出這段sql錯誤的原因，並幫我改正内容：這段SQL的錯誤原因是在條件中缺少結尾的。另外，在子查詢外面的FROM子句中需要指定表別名。\n\n以下是更正後的SQL：\n\nSELECT T.* \nFROM (\n SELECT A.ID ,\n ROW_NUMBER() OVER(ORDER BY A.CREATE_TIME DESC )ITEM,\n A.YEAR_NO ,\n A.WORK_DATE ,\n A.PLAN_ACHIEVE_RATE ,\n A.CREATE_BY ,\n A.CREATE_TIME ,\n A.EDIT_BY ,\n A.EDIT_TIME \n FROM C_PLAN_ACHIEVE_RATE_T A \n WHERE A.DEL_FLAG = 0\n <if test= "V_YEAR_NO IS NOT NULL">\n AND YEAR_NO = #{V_YEAR_NO}\n \n) T\nWHERE T.ITEM > #{V_PAGE - 1} * #{V_ROWS}\nAND T.ITEM < #{V_PAGE * V_ROWS}