Hello,

Since you have 20 points, I assume that you are not new here have a relative idea about posting data on forums. If you don't then there is a detailed article about it in my signature. If you still don't get it 😛 then this is how its done :

Create table Ex

(

CaseID Varchar(20),

Comments Varchar(100),

Userlogin Varchar(10)

)

Insert Into Ex

Select '1243546457', 'Great help','UserA'

Union ALL

Select '3123234353', 'AWESOME','UserB'

Union ALL

Select '2131314242', 'Support was terrible','UserC'

Union ALL

Select '2131314242', 'Support was terrible','UserC'

Union ALL

Select '2131314242', 'Support was terrible','UserC'

Union ALL

Select '2131314242', 'Support was terrible','UserA'

Union ALL

Select '3453453453', 'Could have been better','UserB'

Select CaseId, Comments, UserLogin

From

(

Select *, ROW_NUMBER() Over(Partition By CaseId, Comments, UserLogin Order By CaseId) As rn From Ex

) As a

Where rn = 1

The above is the code which includes the table script, sample data and the query for your requirement.

Hope this is what you are looking for. 🙂

From next time please help us by posting table scripts and sample data as a string of insert statements so that people don't have to type it themselves and can rather use the script provided by you.