Filter for unique records

[Guest]

i have a table with
id seq group
1 AA 1
2 AB 1
3 AA 2
4 AB 2
5 ABC 3
6 BCA 3
7 ABC 4
8 BCA 4

now, i want to filter this data set so that, it comes with unique seq only
like
1 AA 1
2 AB 1
5 ABC 3
6 BCA 3

but, remember, this is not what I want??

1 AA 1
4 AB 2
5 ABC 3
8 BCA 4

that means in the data set there are same seqs assigned to different Group,
but i want all this similar seq to be in a single group and delete other
groups with duplicated seq. i tried

SELECT grouping.seq, last(grouping.groupno)
FROM grouping group by grouping.seq;

which gave me the unique seq but with results what i did not wanted (above
example)

Please, help me

 

[Guest]

Hello. In the querie use the Totals option (it's the symbol of sum in excel)
then in the column of Total row choose First.

I hope it helps.

Regards,
Marco