Distinct Query

[Anon]

Dear Readers,

I'm wondering about the effect of this query:

SELECT DISTINCT prov FROM camping ORDER BY code;

when I do this I get all records while if I use this query (without order by function):
SELECT DISTINCT prov FROM camping;

I only get the 12 results.

What to do to get the result sorted by the number? Because when the collumn prov ='Zuid Holland' then the code starts with '02••••••' where the stars are random other numbers.

Gr.

Kasper

[Anon]

You need to do:
SELECT DISTINCT code, prov FROM camping ORDER BY code;

Diego