SQL SERVER – Fix: Error 130: Cannot perform an aggregate function on an expression containing an aggregate or a subquery | Journey to SQL Authority with Pinal Dave

Fix: Error 130: Cannot perform an aggregate function on an expression containing an aggregate or a subquery Following statement will give the following error: “Cannot perform an aggregate function on an expression containing an aggregate or a subquery.” MS SQL Server doesn't support it. USE PUBS GO SELECT AVG(COUNT(royalty)) RoyaltyAvg FROM dbo.roysched GO You can… Continue Reading...

Source: SQL SERVER – Fix: Error 130: Cannot perform an aggregate function on an expression containing an aggregate or a subquery | Journey to SQL Authority with Pinal Dave