Hi, I am little bit confused about filtering SQL query's. My table: ROWID V A B =================== 1 0 0 1 2 0 0 2 3 0 1 1 4 0 1 2 5 1 0 2 6 2 0 2
With my SQL knowledge I am able filter the result Like this: SELECT rowid,* from table WHERE V==0 | V==1; ROWID V A B =================== 1 0 0 1 2 0 0 2 3 0 1 1 4 0 1 2 5 1 0 2 But additionally, I need to eliminate duplicate (A+B) rows. My wanted result is: ROWID V A B =================== 1 0 0 1 3 0 1 1 4 0 1 2 5 1 0 2 Anybody has a hint for a SQL beginner? The operation shall be as compact as possible because I have to run it on a embedded system with large tables. Thanks in advance Maik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users