aggregate error?

  • Thread starter Thread starter AJ
  • Start date Start date
A

AJ

I am getting the following error: "you tried to execute a query that
does not include the specified expression 'Y' as part of an aggregate
function. Any ideas?

select TOP 5 sum(x)
from tableA
order by y;

HELP!! Thanks.
 
You didn't see the reply to your earlier post where you provided more info?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Function Error 1
Aggregate Function Error 0
aggregate functions 3
Simple SUM: 3 columns – error 4
aggregate function 5
acess sum 7
Aggregate Function in a query 4
Select First(Field1) From Table1 Order By Field1 3

Back
Top