It took me awhile, but I found out how to do what I wanted:

SELECT TOP (100) PERCENT MAX(DISTINCT Pontos) AS Expr2, COUNT(DISTINCT IMEI) AS Expr1, Nome, Empresa

FROM dbo.tmngo

GROUP BY...

Thank you for pointing that out 🙂

I've now changed the field types.

And I would like to do something like this:

SELECT Pontos, IMEI, Nome, Empresa

FROM tmngo

GROUP BY...

Hi,

Thank you both for your answers.

Here is some more info on the table:

Columns:

ID (PK, int, not null)

Pontos (int, null)

IMEI (nvarchar(50),null)

Nome(text,null)

Empresa(text,null)

What happens is that the way data is entering the database...