select statement without including duplicate data

Question

I am trying to select from a database but because the database as duplicate data and the item names in each data may or may not be duplicated. Please look at the example below to understand more

Table shoe

shoeid   pid  Name 
1         1    green
2         1    green
3         2     red
4         3     red

Thats a simple example.

How I can I select Name and pid from this table but i dont want to see any repeated numbers or names. for example i don't want to see red or green or whatever color i have in the database more than once. Please remember I have over 100 colors in the database. The same thing apply to the pid

score 1 · Accepted Answer · 2013-08-26 10:11:33Z

1

Use DISTINCT

http://www.mysqltutorial.org/mysql-distinct.aspx
http://www.w3schools.com/sql/sql_distinct.asp

This might be what you want

this gives you only unique results

SELECT DISTINCT Name, pid FROM shoe;

edited Aug 26, 2013 at 10:11

answered Aug 26, 2013 at 9:55

user753676

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

1 Comment

user753676 Over a year ago

don't forget accepting the answer as correct answer so your question is marked as resolved ;-)

Omesh · Accepted Answer · 2013-08-26 10:08:56Z

1

try this:

SELECT DISTINCT Name FROM table_name;

or if you want maximum id in output:

SELECT Name, MAX(pid) AS id FROM table_name GROUP BY Name;

or if you want comma separated list of ids for that Name:

SELECT Name, GROUP_CONCAT(pid) AS id_list FROM table_name GROUP BY Name;

answered Aug 26, 2013 at 10:08

Omesh

29.4k6 gold badges44 silver badges51 bronze badges

4 Comments

Omesh Over a year ago

OP is not clear as OP don't want any repeated 'numbers or names' instead of 'numbers and names'

user753676 Over a year ago

"How I can I select Name and pid"

Omesh Over a year ago

using SELECT DISTINCT Name, pid. Anyways as OP has accepted your answer. Now we know that's what he wanted. May be I didn't get it properly.

user753676 Over a year ago

see my answer, the question is already answered ;-) no problem =)

웃웃웃웃웃 · Accepted Answer · 2013-08-26 09:54:25Z

0

Use GROUP BY

select * from `yourtable` group by `pid`,`Name`

answered Aug 26, 2013 at 9:54

웃웃웃웃웃

12k15 gold badges63 silver badges95 bronze badges

Comments

sudhakar · Accepted Answer · 2013-08-26 10:00:59Z

0

SELECT DISTINCT Name FROM shoe

this query get the unique values , if you want where you can use it by

 SELECT DISTINCT Name FROM shoe WHERE your_key = 'your_key_val'

answered Aug 26, 2013 at 10:00

sudhakar

5721 gold badge3 silver badges13 bronze badges

Collectives™ on Stack Overflow

select statement without including duplicate data

4 Answers 4

1 Comment

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related