SQLite Select DISTINCT Values of a Column without Ordering

Question

I would like to know whether its possible to get a list of distinct values in a SQLite Column without ordering them.

I tried following query. But it automatically orders the unique text into ascending order.

SELECT DISTINCT column FROM table;

Ex.

Column

Mathew Mathew John John John Numbers Numbers 

---

Result

John Mathew Numbers 

But I would like it not to be ordered. Would like it in Mathew, John, Numbers

Thanks.

Answer 1

What order do you want?

If you want to get the values in the order of first appearance you can do:

select distinct column   from table  order by min(rowid);