unique records

[otuatail]

I have a table that logs every page a user looks at. It stores the IP address as well as the page being viewed. What I want is an SQL that shows IP address that only aperars once. I realise that IP address's are not static.

The field in the table is `IP`

 

Paul.

 

[kickstart]

Hi

 

SELECT DISTINCT IP From SomeTable

 

However not sure if you want just those where there is only a single row for an IP address

 

SELECT IP, COUNT(*) AS IpCount FROM SomeTable GROUP BY IP HAVING IpCount = 1

 

All the best

 

Keith

[fenway]

You can do something similar with MAX() without incurring any HAVING performance penalties.

[kickstart]

You can do something similar with MAX() without incurring any HAVING performance penalties.

 

I think I must have brain fade as I cannot see how at the moment and I would prefer to avoid using HAVING.

 

All the best

 

Keith

[fenway]

You can do something similar with MAX() without incurring any HAVING performance penalties.

 

I think I must have brain fade as I cannot see how at the moment and I would prefer to avoid using HAVING.

 

All the best

 

Keith

No, my turn for brain fade.... I didn't read the OP's question closely enough.