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 Name,min(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 id,name,email from tablename group by id,name,email

Anu V · Answer

thanks for your replay..

Mangesh G · Answer

Hi Anu, Can u try this Select Max(UserName)as UserName,MIn(Title) as Title,Min(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 G · Answer

Hi Anu You Can try like this Select Distinct Col1,Col2 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?

Answers (7)