I want to count records

Ramon Quintana

7y802SQL

Hi i used this sql to get this information:

SELECT Cuentas_Maestro.Functional_Area, Area_Funcional.Functional_area_Desc

FROM Area_Funcional INNER JOIN Cuentas_Maestro ON Area_Funcional.Functional_area = Cuentas_Maestro.Functional_Area
WHERE (((Area_Funcional.Tipo_de_costo)="costo"))

Notice that there are more than 2 codes in the camp1, so i want to group thay camp in order to know how many records have code 7010 and how many code have 7011.

Some SQL command to add in my initil query?

Thanks for help.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Kumar7y ago
Accepted answer
Hi,

If you want to count the records. Then you have to use group by those coulmn name which you want. like this
SELECT working_area, COUNT(*) FROM agents GROUP BY working_area;
But no of records is know better compare to anyone becaue you have database and datatable. So you know better.

Prefer the below link.

https://www.w3resource.com/sql/aggregate-functions/count-with-group-by.php
+3
Ramon Quintana7y ago
IT WORKS WITH THIS
SELECT Cuentas_Maestro.Functional_Area, Area_Funcional.Functional_area_Desc, Count(*) AS Total_Registros
FROM Area_Funcional INNER JOIN Cuentas_Maestro ON Area_Funcional.Functional_area = Cuentas_Maestro.Functional_Area
WHERE (((Area_Funcional.Tipo_de_costo)="costo"))
GROUP BY Cuentas_Maestro.Functional_Area, Area_Funcional.Functional_area_Desc;
0