¡@
2014/10/16 ¤W¤È 08:25:34
android Programming Glossary: t._idAndroid SQLite performance in complex queries http://stackoverflow.com/questions/13401642/android-sqlite-performance-in-complex-queries team_id team_name SUM gp gp SUM w w SUM t t SUM l l SUM GO go SUM GA ga SUM GO SUM GA score SUM 2 w t p FROM SELECT t._id team_id t.name team_name COUNT CASE WHEN score_home IS NOT NULL THEN 1 END gp COUNT CASE WHEN score_home score_away THEN.. THEN 1 END l SUM score_home go SUM score_away ga FROM team_table t LEFT OUTER JOIN match_table m ON m.team_home t._id WHERE t.tournament_id GROUP BY t._id t.name UNION ALL SELECT t._id team_id t.name team_name COUNT CASE WHEN score_away.. score_away ga FROM team_table t LEFT OUTER JOIN match_table m ON m.team_home t._id WHERE t.tournament_id GROUP BY t._id t.name UNION ALL SELECT t._id team_id t.name team_name COUNT CASE WHEN score_away IS NOT NULL THEN 1 END gp COUNT CASE..
|