新的一年,从基础的增删改查开始,复习巩固一下过往一年之所学,希望能不断勉励提高自己;
本节为select语句汇总
语句一:
select col1,col2,col3 from table1 join table2 on 条件1
语句二:
select col1,col2,col3 from table1,table2 where 条件1
语句三:
SELECT column_name(s) FROM table_name1 UNION SELECT column_name(s) FROM table_name2
语句四:
select col1,sum(col2) from table1 group by col1