Want to calculate the sum of the count rendered by group by option..
- by Vijay
i have a table with the columns such id, tid, companyid, ttype etc..
the id may be same for many companyid but unique within the companyid and
tid is always unique and
i want to calculate the total no of transactions entered in the table,
a single transaction may be inserted in more than one row,
for example,
id tid companyid ttype
1 1 1 …