我的查詢語句是: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數據庫,我想使 stuavg字段得出來的數字都保留兩位小數,查詢表達式應該怎么寫(chinese,math,english字段都是number型)。
問個關于sql查詢表達式的問題
慕斯709654
2018-07-23 09:10:25