Posts by Carlos Aguiar • 41 points

• 3

  votes

  5

  answers

  57768

  views

  A: Count equal records with SELECT DISTINCT and COUNT

  I sought the same help and this was a solution that worked. SELECT DISTINCT campo1 ,campo2 ,campo3 ,campo4 ,campo5 ,campo6 ,campo7 ,COUNT(*) AS quantidade FROM tabela_a GROUP BY campo1 ,campo2…

  mysql sqlfiddle

  answered 8 years, 5 months ago Carlos Aguiar 41