SQL语句必知必会
https://blog.csdn.net/yuhk231/article/details/87279737
SQL速学教程
https://blog.csdn.net/yuhk231/article/details/87279737
Sql强制类型转换
Cast(X as double )
SQL除法
x/y over()
https://www.cnblogs.com/wangpei/p/4445038.html
SQL SELECT DISTINCT 语句
https://www.w3school.com.cn/sql/sql_distinct.asp
SELECT DISTINCT 列名称 FROM 表名称
SQL left outer join
https://www.cnblogs.com/jingshan/p/9237631.html
https://www.cnblogs.com/wwjchina/p/9328472.html
SQL查看表结构
desc tabelname
sql in 根据指定id查找记录
select * From 表 Where id in (1,5,3) order by instr(',1,5,3,',',CONCAT(',',id,','))
SQL取交集
https://www.cnblogs.com/kissdodog/archive/2013/06/24/3152743.html
SELECT Name FROM Person_1
INTERSECT
SELECT Name FROM Person_2
SQL 表查找相同字段并连接 left outer join
( SELECT Name FROM Person_1 ) a
LEFT OUTER JOIN
( SELECT Name FROM Person_2) b
on a.xx=b.xx