![](https://lstatic.shangxueba.com/jiandati/pc/images/pc_jdt_tittleico.png)
现有员工工资表(PAYMENT),其字段包含如下:员工号(EmployeeID)C(10),基本工资(BaseFee)N (8.2),津
现有员工工资表(PAYMENT),其字段包含如下:员工号(EmployeeID)C(10),基本工资(BaseFee)N (8.2),津贴(SubsidyFee)N(8.2),奖金(AwardFee)N(8.2),保险扣除(’InsuranceFee)N(8.2)。现要求为“工资”表增加一个“实发工资”字段(RealFee),类型为数值型,正确SQL命令是()。
A. ALTER TABLE PAYMENT ADD COLUMN RealFee N(8,2)
B. ALTER TABLE PAYMENT ADD FIELD RealFee N(8,2)
C. MODIFY TABLE PAYMENT ADD COLUMN Re,Fee N(S,2)
D. MODIFY TABLE PAYMENT ADD FIELD RealFee N(8,2)
![](https://lstatic.shangxueba.com/jiandati/pc/images/jdt_panel_vip.png)