Quick SQL group by question.

Question

Let's say I have a table with 2 columns number and name.

number  name 
--------------
0       name1
3       name4
3       name2
5       name1

So the number column has repeats in it and one or more (distinct) names assigned to each number. But for example, number 3 could have the same name as number 5.

How do I show all the distinct names for each number using group by in such a way that I get as a result both number and name.

I am trying to do this but I can't figure it due to must having the columns in SELECT in GROUP BY also.

Answer 1

Is this what you want?

SELECT NUMBER, NAME
  FROM TABLENAME
    GROUP BY NUMBER, NAME
    ORDER BY NUMBER

Answer 2

I don't think you need to group:

SELECT DISTINCT NUMBER, NAME
FROM TABLENAME
ORDER BY NUMBER

should do it, or am I missing something?

Answer 3

First Thing 'Number' is a reserved word in sql so don't use it as a column name

Suppose your 'Number' column name is 'Number1"

then try this

select name, number1 from tableName GROUP BY name, number1