我的查詢語(yǔ)句是：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ù)庫(kù)，我想使 stuavg字段得出來(lái)的數(shù)字都保留兩位小數(shù)，查詢表達(dá)式應(yīng)該怎么寫(xiě)（chinese,math,english字段都是number型）。
問(wèn)個(gè)關(guān)于sql查詢表達(dá)式的問(wèn)題
慕斯709654
2018-07-23 09:10:25
