CODEWITHSUNDEEP
mysqlsqlsql-server
Sapna
Sapna

Reputation: 53

how many times a unique "callingNumber" is recorded for the same "CallReasonName"

i need to get your help regarding the below cases. i have a table with two columns "CallingNumber" that contain different redundant phone numbers and "CallReason" the reason for why they recorded.

 then i need a query to generate 
     => how many times a unique "callingNumber" is recorded for the same "CallReasonName".

Upvotes: 0

Views: 30

Answers (1)

Reza
Reza

Reputation: 19913

I don't know if I understand you well or not, but I think it is a simple Query as

Select callingNumber, CallReasonName, count(1) as Cnt
from table
Group by callingNumber, CallReasonName

Upvotes: 1

Related Questions