4、大小写关键字使用大小写,表名列名使用小写,如下 SELECT col_1,col_2,col_3, COUNT(*) FROM tbl_A WHERE col_1='a' AND col_2=(SELECT MAX(col_2) FROM tbl_B WHERE col_3=100) GROUP BY col_1,col_2,col_3 花了...
复制代码4、大小写关键字使用大小写&xff0c;表名列名使用小写&xff0c;如下SELECT col_1,col_2,col_3, COUNT(*) FROM tbl_A WHERE col_1&61;39;a&39;AND col_2&61;(SELECT MAX(col_2) FROM tbl_B WHERE col_3&61;100) ...