SELECT c FROM mytable WHERE b IS NOT c Is this what you mean?
Imanuel Am 29.11.2012 07:45, schrieb YAN HONG YE: > b c > 897313 897313 > 854809 868763 > 854808 854809 > 854980 854808 > 854974 854980 > 854973 854974 > 854780 854973 > 854778 854780 > 854769 854778 > 854768 854769 > 854738 854768 > 854691 854738 > 854690 854691 > 853709 854690 > 856707 853709 > 856697 856707 > 856695 856697 > 927681 856695 > 927696 927681 > 927695 927696 > 927694 927695 > 927693 927694 > 927692 927693 > 927691 927692 > 927690 927691 > 927690 > 910986 > 910985 > I have a table like this, how to get result not exists:b=c > > my command is : > select c from mytable where not exists( b=c); > but not correct. > how to get correct result? > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
