Take data from table, make a list of unique values

[KK]

I have a table which has rows and rows that look like this:

A, 1
A, 2
A, 3
A, 3
A, 3
B, 1
B, 2
B, 2
B, 2
B, 3

I want to create a query that gives me something like this:

A, 1
A, 2
A, 3
B, 1
B, 2
B, 3

Basically create a table of unique values for each letter instead on
repeating ones.

How do I do this? Thanks.

 

[pietlinden]

I have a table which has rows and rows that look like this:

A, 1
A, 2
A, 3
A, 3
A, 3
B, 1
B, 2
B, 2
B, 2
B, 3

I want to create a query that gives me something like this:

A, 1
A, 2
A, 3
B, 1
B, 2
B, 3

Basically create a table of unique values for each letter instead on
repeating ones.

How do I do this? Thanks.

SELECT DISTINCT field1, field2
FROM MyTable
ORDER BY field1, field2;

 

[KK]

One thing I just found out is that if I click on "Total" (while
creating query), the "group by" does this.

but thanks.