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)

John Penn · Answer

SELECT DISTINCT SmallImageBigImageAddressCity FROM Gallery1

Manish Dwivedi · Answer

Because Id will be different for each row. remove id from the query then apply the group by clause. u will get the unique result.

Manoj Bisht · Answer

I've to bring four fields........ IDSmallImageBigImageAddressCity

Manish Dwivedi · Answer

No This query will not give the correct result as you want. Your inner query is working fine and it gives the unique SmallImage. But when outer query fires then it will not give the correct result. Tell me the total fields u want in the query result. Happy Coding!!