(Jeff Smith) Every now and then you may attempt to calculate an aggregate function — such as SUM() — on a correlated subquery, only to encounter the following error: Msg 130, Level 15, State 1, Line 24 Cannot perform an aggregate function on an expression containing an aggregate or a subquery.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help