Microsoft Sql Server Management Studio在选择列表中无效

Question

我试图从我的表中搜索并使用group by，但我在执行查询时收到错误。下面是我的查询，我得到的错误：

select * from loans where ac_no='100001' group by ac_no, branch 

和错误：

Msg 8120, Level 16, State 1, Line 1
Column 'loans.gl_no' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

请，我究竟做错了

Answer 1

如果你想聚集的东西...

select ac_no, branch, count(*) 
from loans 
where ac_no = '100001' 
group by 
    ac_no 
, branch 

如果你只是想选择行，你不需要group by

select * 
from loans 
where ac_no = '100001' 

如果您尝试选择不同的行...

select distinct * 
from loans 
where ac_no = '100001'