SELECT (CASE WHEN RJ_CONSTRUCTION_METHODOLOGY NOT LIKE '%AERIAL%' OR RJ_CONSTRUCTION_METHODOLOGY IS NULL THEN NVL(CALCULATED_LENGTH,0) (CASE WHEN RJ_CONSTRUCTION_METHODOLOGY
SELECT * FROM `tbl_methodology` WHERE FIND_IN_SET(6, `col_select_corporate`)
,从这个结果中,我想得到有最大日期的记录SELECT * FROM `tbl_methodology` WHERE id IN (1,5,7) AND `col_date` = (有谁可以帮我??