Sample MySql statement

同部門各季的銷收未稅額比較

• SELECT mid(SerialNo,4,2) AS yr,TRUNCATE((mid(SerialNo,6,2)+2)/3,0) AS season, SUM(beforeTax) FROM DCT.DCT_SOMAIN WHERE mid(SerialNo,4,2) in ( '93','94','95','96','97' ) AND SUBSTRING_INDEX(Dept,'.',1) regexp 'FSS*' GROUP BY yr,season

各部門最近5年各年的業績比較

• SELECT SUBSTRING_INDEX(Dept,'.',1) AS dep,mid(SerialNo,4,2) AS yr, SUM(beforeTax) FROM DCT.DCT_SOMAIN WHERE mid(SerialNo,4,2) in ( '93','94','95','96','97' ) AND SUBSTRING_INDEX(Dept,'.',1) regexp '[HIPCF]SS+' GROUP BY dep, yr