Miha Vrhovnik wrote:
So How can I select DISTINCT ON 1st column OR any other. as sqlite does not support DISTINCT ON (column1, column2, ....)
What does it mean to select distinct on one column only? If you have a table with two rows 1,1 1,2 and you want to select distinct on the first column, which one would you want? How is the engine supposed to decide?Igor Tandetnik
