Question

excel 中 sql 语句，select sum() as 字段1，sum() as 字段2，字段3 from [表1]

怎样能实现
select *,（字段1/字段2）as 字段3 from (select sum() as 字段1，sum() as 字段2，字段3 from [表1] )
应该是
（字段1/字段2）as 字段4

Answer 1

select A.*,（A.字段1/A.字段2）as 字段4 from (select sum() as 字段1，sum() as 字段2，字段3 from [表1] ) A

加个别名就行了

Answer 2

我感觉你先设置个变量
declare @字段1 int
set @字段1=select sum()
这样比较好

Answer 3

没明白，用ODBC连接excel文件吗？这个SQL有什么问题呢？