Count database records without repeating

Question

I have a table that has several records with the same information, example:

id |  nome      |  profissao
1     Carlos       Pedreiro
2     Jean         Garçon
3     Victor       Pedreiro
4     Ana Paula    Secretaria
5     Paula        Secretaria
6     Karina       Balconista

What I need to count is the amount of profession but without repeating, in the example I gave, has 6 records, but only has 4 different professions, this is what I need to count, I do not know how to count but without repeating

Answer 1

Do it this way:

SELECT
   t.profissao,
   COUNT(t.profissao) as total
FROM
   tabela t
GROUP BY
   t.profissao

In the SELECT place COUNT(t.profissao), grouping by the same field, ie, GROUP BY t.profissao. This way he will return the number of repetitions of each profession, and to know which profession belongs to the quantity shown, just add the field profissao, as shown in query above.

The result of the query would be more or less this:

total     |  profissao
2            Pedreiro
1            Garçon
2            Secretaria
1            Balconista