In group by clause, you should include all the columns present in the select list that are not aggregated.

So, in this example include all the columns in the group by...

Hi,

1. Using Stored Procedure requires permission .

Only the members of the sysadmin fixed server role, the db_owner fixed database role, or the owner of the object can execute sp_rename.

2....