What will be the query for this: I have to find the total count of a particular customer ID occuring in a ,say, Sales Table
Printable View
What will be the query for this: I have to find the total count of a particular customer ID occuring in a ,say, Sales Table
it is quite simple,
select cust_id, count(*) from supp
group by cust_id;
the above query displays each cust_id along with number of records in supp table for that custormer id
The above solution gives the count of all customers with the same id....so
select cust_id, count(*) from supp
WHERE cust_id = <<id value>>
group by cust_id;