SQL syntax error in query expression

Question

Im trying to run this query

select customerID, sum(OrderID)
from employee_T
where 2 < select(sum(OrderID) from employee_T)
group by customerID;

I want to list the customer id and the total number of orders placed for every customer that has more than 2 orders.

I get the syntax error on this line

where 2 < select(sum(OrderID) from employee_T)

is it because of the 2?s

Blorgbeard · Accepted Answer · 2013-04-21 21:29:46Z

3

I'm not familiar with ms-access syntax, but this is how you would do that in regular sql:

select customerID, count(OrderID)
from employee_T
group by customerID
having count(orderID) > 2

answered Apr 21, 2013 at 21:29

Blorgbeard

104k50 gold badges237 silver badges276 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Blorgbeard Over a year ago

having allows the use of aggregate functions like count, because it is applied after the grouping. where filters the rows before they are grouped, having filters them afterwards.

Collectives™ on Stack Overflow

SQL syntax error in query expression

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related