Count() can be used in the "where" for delimiter records with value > Number,

Question

SELECT   numero_documento,COUNT(*) AS cuantos
FROM dbo.PERSONAL 
GROUP BY numero_documento 
order by cuantos desc ;

I need only records with value of "Cuanto" > 1

Add `Having COUNT(*) > 1` after the group by. This is pretty basic question. You might want to delete it. — Daniel Gimenez, Feb 15 '18 at 15:30

score 0 · Accepted Answer · answered Feb 15 '18 at 15:31

0

Add having to the query

SELECT   numero_documento,COUNT(*) AS cuantos
FROM dbo.PERSONAL GROUP BY numero_documento 
having count(numero_documento) > 1
order by cuantos desc

answered Feb 15 '18 at 15:31

Ven

2,011
1
13
27

score 0 · Answer 2 · answered Feb 15 '18 at 15:57

Sometimes it is helpful to see another way to do something. I'm not claiming this way to be better, but it works.

Use a Sub Query like this

Select * from
(
  SELECT   numero_documento,COUNT(*) AS cuantos
  FROM dbo.PERSONAL 
  GROUP BY numero_documento 
) G1
WHERE cuantos > 1
order by cuantos desc

Count() can be used in the "where" for delimiter records with value > Number,

2 Answers2