数据库语句100句

,SUM(CASEWHENC#='004'THENscoreELSE0END)/SUM(CASEC#WHEN'004'THEN1ELSE0END)AS数据库平均分，100*SUM(CASEWHENC#='004'ANDscore>=60THEN1ELSE0END)/SUM(CASEWHENC#=AccessDatabase:SELECTiif(len(field)>2,left(field,2)+'',field)FROMtablename;e说明Execute方法该方法用于执行SQL语句com/it/u=3584456625,1087521099&fm=253.jpg">