Loading

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

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

Anu V

Anu V

10y1.2k

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

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ananth G10y ago
Accepted 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;
0
Harshal Patil10y ago
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
0
Anu V10y ago
thanks for your replay..
0
Mangesh G10y ago
Hi Anu,

Can u try this

Select Max(UserName)as UserName,MIn(Title) as Title,Min(ItemID) as ItemID from [User] group By UserName
0
Anu V10y ago
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
0
Mangesh G10y ago
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
0
Brijesh Rathor10y ago
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.
0