If I wanna to know how much z>12.5 result in the database,could I use this following cmd? SELECT * from TableA WHERE z in ( SELECT z FROM TableA GROUP BY z HAVING count(z>12.5)=2 );
_______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
