这个sql怎么写？？

Question

我的表：
mytable（No,name,gread1,gread2,gread3）我希望在ADOQuery里增加个字段，greadsum＝gread1+gread2+gread3我该怎么写这个select呢？？

Answer 1

select gread1+gread2+gread3 as greadsum from table

Answer 2

select No,name,gread1,gread2,gread3，gread1+gread2+gread3 as greadsum from table
就这样写

Answer 3

select No,name,gread1,gread2,gread3，gread1+gread2+gread3 as greadsum from table

Answer 4

SELECT *，GREAD1+GREAD2+GREAD3“GREADSUM” FROM mytable

Answer 5

SELECT *，GREAD1+GREAD2+GREAD3“GREADSUM” FROM mytable