[sqlite] Select top 1 from duplicate values

[Quan Yong Zhai]

sqlite> create table mytable(f1 integer,f2 integer,f3 integer);
sqlite> insert into mytable 
values(1,2,8),(1,3,9),(2,4,8),(2,5,2),(3,6,4),(3,7,8),(4,2,4);
sqlite> select f1, max(f2), f3 from mytable where (f3&8)!=0 group by f1;
1|3|9
2|4|8
3|7|8
sqlite>