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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
