In SQL how to I select DISTINCT over multiple columns?

Question

In SQL how to I select DISTINCT column over multiple columns?

Ananth G · Answer

CREATE TABLE Persons ( Name varchar(255) Title varchar(255) Itemid int ); insert into Persons values ('xxx' 'Title1' 123); insert into Persons values ('yyy' 'Title2' 124); insert into Persons values ( 'xxx' 'Title3' 125); insert into Persons values ('zzz' 'Title4' 126); select Namemin(Itemid) from Persons a group by Name;

Harshal Patil · Answer

Suppose you have 3 column Id name and Email then for select Query is : Select idnameemail from tablename group by idnameemail

Anu V · Answer

thanks for your replay..

Mangesh Gaherwar · Answer

Hi Anu Can u try this Select Max(UserName)as UserNameMIn(Title) as TitleMin(ItemID) as ItemID from [User] group By UserName

Anu V · Answer

my table look like User Name Title Item ID xxx Title1 123 yyy Title2 124 xxx Title3 125 zzz Title4 126 I need a select query for result look like as below User Name Title Item ID xxx Title1 123 yyy Title2 124 zzz Title4 126

Mangesh Gaherwar · Answer

Hi Anu You Can try like this Select Distinct Col1Col2 from Table1 Where col1='Your Condition' It will list down Output like this Col1 Col2 1 3 1 4 5 1 So basically it will give u Unique of the Combination of the Columns

Brijesh Rathor · Answer

Hi u can check this link. http://stackoverflow.com/questions/54418/how-do-i-or-can-i-select-distinct-on-multiple-columns Hope this will help u.

In SQL, how to I select DISTINCT over multiple columns?