Mysql query select 2 values with 1 Distinct

Question

My table structure -

username : website

I want to select only unique websites
I have tried running this query -

SELECT DISTINCT username,website from asd

But it selects the unique combination

example -

John    www.google.com 
Jack    www.google.com 
Tom     www.facebook.com

Query should return
John - www.google.com
Tom - www.facebook.com

Thank you

Why not Jack and tom and on what basis are you saying John should come? — Fahad Anjum, Jun 15 '17 at 05:29
What is the logic by which John's record is retained over Jack's record? — Tim Biegeleisen, Jun 15 '17 at 05:30
John OR Jack should be ignored because google.com is not unique — Tomas Randomas, Jun 15 '17 at 05:36

score 3 · Accepted Answer · answered Jun 15 '17 at 05:34

3

You can just use GROUP BY in your case:

SELECT username, website FROM asd GROUP BY website

answered Jun 15 '17 at 05:34

cypryradu

56
3

Amazing solution, worked like a charm. Thank you. – Tomas Randomas Jun 15 '17 at 05:41

score 0 · Answer 2 · answered Jun 15 '17 at 05:32

0

When you are using DISTINCT with more then one column, then it will search for distinct among the paired columns. So the data you are getting is absolutely right.

For your requirement, please elaborate why John is needed and not Jack?

answered Jun 15 '17 at 05:32

Mayank Pandeyz

25,704
4
40
59

John OR Jack should be taken , since google.com is a duplicate – Tomas Randomas Jun 15 '17 at 05:39
And how you decide either it is John OR Jack ? – Mayank Pandeyz Jun 15 '17 at 05:41
I guess it's up to mysql's logic. This task of mine is not so important , so i can leave it for mysql to choose. But i would also like to know how to decide that – Tomas Randomas Jun 15 '17 at 05:46

Mysql query select 2 values with 1 Distinct

2 Answers2