Show distinct values

[MKleusberg]

While looking at this I noticed that it might be nice to have some way of getting a list of unique values of a column. For example, when I want to know which countries are included in the data set, I have to download the database and run this SQL statement:

SELECT DISTINCT adm0_name FROM WFPVAM_FoodPrices;

It would be nice to be able to get the same list by clicking some icon or whatever :)

[justinclift]

Heh Heh Heh

We might need to add the equivalent of an "Execute SQL" tab directly in the browser. Can't see it happening soon though. 😄

[chrisjlocke]

Alternatively, each column could have a list of distinct values which could also be used as a filter. Similar approach to Excel.