MySql Distinct with multiple fields

Question

I have 4 columns a, b c, d in my table (MySQL database) . I want to select the distinct values of ALL of these 4 columns in my table . More deeply my table is given bellow..

a   b   c   d
--------------------------
1   3   3   4
1   2   3   0
1   1   3   4
1   2   3   4
1   2   3   4
1   2   3   4
1   2   3   4

In the above table (1,2,3,4) value are repeating 4 times(look the last 4 rows of my table). I want only the distinct one , ie i want to get the bellow table after mysql query..

a   b   c   d
---------------
1   3   3   4
1   2   3   0
1   1   3   4
1   2   3   4

I think you guys got some idea . Im not familier with MySql .

Which one do you want? Note that in the absence of a PRIMARY KEY a 'table' is not really a table in an RDBMS sense. — Strawberry
– Strawberry, Commented Apr 2, 2014 at 9:48

juergen d · Accepted Answer · 2014-04-02 09:44:11Z

8

select distinct a,b,c,d from your_table

answered Apr 2, 2014 at 9:44

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

freakydev Over a year ago

Its working well..I have 1 more need , ie there is 2 more fields in ma table(e & f). I want to get the corresponding values also.How can i do that??

Sulthan Allaudeen Over a year ago

jsut add select distinct a,b,c,d,e,f from your_table

freakydev Over a year ago

I want to avoid that field from unique condition.If i add that filed also then , does the mysql check the unique condition for that field also??

juergen d Over a year ago

Yes, it does. But if you don't want those other fields to be unique you have to define a rule which one to take because you can't take all, right? Would be best to ask another question and add your example data and expected output.

Sulthan Allaudeen · Accepted Answer · 2014-04-02 09:44:59Z

2

SELECT DISTINCT column_name,column_name FROM table_name;

I mean

select distinct a,b,c,d from table_name;

Here is the link of w3schools

answered Apr 2, 2014 at 9:44

Sulthan Allaudeen

11.6k12 gold badges51 silver badges66 bronze badges

Comments

Ronald Alexander Kailola · Accepted Answer · 2014-04-02 09:55:35Z

0

use : SELECT DISTINCT * FROM yourtable

answered Apr 2, 2014 at 9:55

Ronald Alexander Kailola

1499 bronze badges

Comments

jmail · Accepted Answer · 2014-04-02 10:39:06Z

0

try this:

SELECT DISTINCT a FROM my_table
UNION 
SELECT DISTINCT b FROM my_table
UNION
SELECT DISTINCT c FROM my_table
UNION
SELECT DISTINCT d FROM my_table

update 1:

SELECT a,b,c,d 
FROM my_table 
GROUP BY a,b,c,d;

http://sqlfiddle.com/#!2/c49ad/11

edited Apr 2, 2014 at 10:39

answered Apr 2, 2014 at 9:58

jmail

6,1503 gold badges23 silver badges35 bronze badges

7 Comments

Shell Over a year ago

what would be the output of this query

Shell Over a year ago

what is the benefit of using Distinct keywords with Group By?

jmail Over a year ago

@Nimesh, if you wants to remove the duplicate means use the distinct or otherwise use the group by like its aggregate operators to each group

Shell Over a year ago

and have you checked your first query result in fiddle?

user3391751 Over a year ago

@jmail OP has already suggested the output and your first query result does not match with the suggested output.

|

Collectives™ on Stack Overflow

MySql Distinct with multiple fields

4 Answers 4

4 Comments

Comments

Comments

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

Comments

Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related