试试这个
SELECT CASE WHEN edition = 'STAN' THEN CASEWHEN has9 = 1 THEN '9' WHEN has8 = 1 THEN '8' WHEN has7 = 1 THEN '7' WHEN hasOLD = 1 THEN 'OLD' ENDWHEN edition = 'SUI' THEN CASEWHEN has9 = 1 THEN 'S9' WHEN has8 = 1 THEN 'S8' ENDELSE 'S7' END AS version
