Unable to perform an aggregate function on an expression containing an aggregate or a subquery.
  • hi please how i can resolve this problem ... Unable to perform an aggregate function on an expression containing an aggregate or a subquery.
    thank you ...  ;) .

     


  • 1 Comment sorted by
  • Vote Up0Vote Down WaqasWaqas
    172.00 Karma Accepted Answer
    Below query will through error
    SELECT SUM(COUNT(Orders.Freight)) AS Freight
    FROM Orders

    SO SOLUTION is
    use relative query like this.

    select SUM(T.Freight)
    From
    (
    select COUNT(Orders.Freight) AS Freight from Orders
    ) T
    - See more at: http://www.codingresolved.com/discussion/2798/cannot-perform-an-aggregate-function-on-an-expression-containing-an-aggregate-or-a-subquery-in-sql/p1

Howdy, Stranger!

It looks like you're new here. If you want to get involved, or you want to Ask a new Question, Please Login or Create a new Account by Clicking below

Login with Facebook

Popular Posts of the Week

    Optimum Creative