A SELECT expression cannot mix aggregate and non-aggregate results;
Fine:
select Name
from SomeTable
or
select COUNT(1)
from SomeTable
Invalid:
select Name, COUNT(1)
from SomeTable
Aggregate functions are listed here.
A SELECT expression cannot mix aggregate and non-aggregate results;
Fine:
select Name
from SomeTable
or
select COUNT(1)
from SomeTable
Invalid:
select Name, COUNT(1)
from SomeTable
Aggregate functions are listed here.