All-Star
194851 Points
28099 Posts
Moderator
Feb 04, 2021 06:32 AM|Mikesdotnetting|LINK
If all you want to do is to get the total number of profilewriters for each MyExpertise, the following should do:
select MyExpertise, Count(MyExpertise) as Total from profilewriters group by MyExpertise
All-Star
194851 Points
28099 Posts
Moderator
Re: Combine 2 sql statement into one
Feb 04, 2021 06:32 AM|Mikesdotnetting|LINK
If all you want to do is to get the total number of profilewriters for each MyExpertise, the following should do:
select MyExpertise, Count(MyExpertise) as Total from profilewriters group by MyExpertise