sql 操作总结

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