It seems that I cannot get other columns
with distinct in the select statement.
I want to do like
select distinct i,a from a where c=2;
Right now I have to do
select distinct i from a where c=2
and then iterate over each i to get a
I have also tried
select a,distinct i from a where c=2
I would appreciate any suggestion
Thanks