我的查詢語句是:SELECT *, [chinese] + [math] + [english] + [history] + [physical] AS tot, <FONT color=#ff0000><STRONG>([chinese] + [math] + [english])/3 AS stuavg</STRONG></FONT> FROM [stureport] ORDER BY [id],用的是access 2003數(shù)據(jù)庫,我想使 stuavg字段得出來的數(shù)字都保留兩位小數(shù),查詢表達(dá)式應(yīng)該怎么寫(chinese,math,english字段都是number型)。
問個關(guān)于sql查詢表達(dá)式的問題
慕斯709654
2018-07-23 09:10:25