Distinct in SQL Server

Question

Hello Friends,

I want to get the information of the record(s) where SmallImage(Field Name) must be unique. For this i'm using the following query. Is it right or not if not plz make it correct


Select * From Gallery1 Where SmallImage in (Select Distinct SmallImage From Gallery1 Where Active=1)