Query

  • Thread starter Thread starter Frank Dulk
  • Start date Start date
F

Frank Dulk

I have a file with the fields: I number cellular, I model, name customer, I
address customer, Zip code customer, cpf customer, neighborhood, uf, address
gives and Zip code gives.
I need a query that swallows me more than 2 number cellular for a same
address and with different CPF.
I made the query->
In (SELECT [numerocelular] FROM [ALL] TMP GROUP BY [numerocelular].
[enderecoentrega] HAVING Count (*) >2 And [enderecoentrega]=[ALL] .
[enderecoentrega])

But I didn't still get what wanted
 
try this

SELECT NumeroCelular, cpf , Count(NumeroCelular) FROM Table
GROUP BY NumeroCelular, cpf
WHERE Count(NumeroCelular)>1

- Raoul
 
Back
Top