SQL中显示在使用条件的上下文中指定了非布尔类型的表达式是什么意思（显示第三行有语法错误）

1.Having子句后面要跟布尔类型的表达 2.别名branch_avg后的(branch_name,avgbalance)也是多余的。修改后： select branch_name,avgbalance from (select branch_name,avg(balance) as avgbalance from account_table group by branch_name) as branch_avg group by branch_name having max(avgbalance) = sum(avgbalance) 也可以这样写：将平均balance降序排序，第一行就是最大的。 select top 1 branch_name,avgbalance from (select branch_name,avg(balance) as avgbalance from account_table group by branch_name) as branch_avg order by avgbalance desc

where 关键字后面 应该跟的是一个判断语句

而你现在括号里的是一个查询语句

可以这样改：

***

where exists (select customer

***

Create rule sex_rule as @sex='男' or @sex='女'

go

exec sp_bindrule 'sex_rule','person.sex'

---