When you say 2 same results, do you mean all the columns listed in the sql are repeating or most of them but there are couple that have different value.
When you do a select distinct like above that means all the values in all the columns have to same in order to be grouped into one distinct record.
P.

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Can you display the full row of two of the duplicate records, please. That will help construct query to filter them out. One thought with SQL Server 2008 is to use ROW_NUMBER() function with an OVER analytical statement; however, would have to know the exact columns that make the row unique/duplicate.

CustomerID 3873 is the duplicate record in your picture from what I can see and it has two different LastLogin values, so you can see if this gets what you want. If it does, then you may need to group by all the columns except for the LastLogin on which you will need to use an aggregate function like MAX or MIN.

The other records all had different data in random columns despite all having first name Shiny. If that is what you are referring to as duplicates, then you will have to decide which is the valid one to keep as DISTINCT won't work there.

Featured Post

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Suggested Solutions

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…