For example, let us consider this table: In this image consists of rows of 8 where names like Mike,Glenn,Daryl,Shane and Patricia is included with their respective ages
Id | Name | Age |
---|---|---|
1 | Mike | 25 |
2 | Glenn | 19 |
3 | Glenn | 19 |
4 | Daryl | 56 |
5 | Shane | 30 |
6 | Shane | 30 |
7 | Patricia | 16 |
Now I want to insert the type of query that will show the names without repetitions like This, not like This
EDIT: I entered the data from first picture. The request is to list the names without duplicates, as shown in the second and third picture but I will not convert them to text.
Advertisement
Answer
DISTINCT specifies removal of duplicate rows from the result set.
SELECT DISTINCT Name FROM tablename
see: use DISTINCT in SELECT