Question

SQL语言 服务器: 消息 170，级别 15，状态 1，行 7 第 7 行: ')' 附近有语法错误。

SELECT AVG(it)
FROM
(
SELECT MAX( 2012 - birth ) as it WHERE sex = 1
UNION ALL
SELECT MIN( 2012 - birth ) as it WHERE sex = 0
)
请问哪里有问题

Answer 1

SELECT AVG(a.it)
FROM
(
SELECT MAX( 2012 - birth ) as it WHERE sex = 1
UNION ALL
SELECT MIN( 2012 - birth ) as it WHERE sex = 0
) a

加个别名就可以了,你试试 我加了别名a

呵呵,你括号里面还少写了from

Answer 2

SELECT MAX( 2012 - birth ) as it WHERE sex = 1
from 呢

追问

谢谢

追答

SELECT AVG(it)
FROM
(
SELECT MAX( 2012 - birth ) as it from student WHERE sex = 1
UNION ALL
SELECT MIN( 2012 - birth ) as it from student WHERE sex = 0
)t