1、count()
2、distinct去重:放在开头 select distinct name from A
3、排名:
①rank() over →1 1 3
SELECT id, name, score, DENSE_RANK() OVER( ORDER BY score DESC) AS ranks FROM student_info
②dense_rank () over →1 1 2
③row_number() over →1 2 3
4、round(col,lenth,function):保留位数,
0四舍五入,1舍去,2向上舍入,3向下舍入,4朝零方向舍入
5、复制表A数据到表B
①A、B结构一样:insert into B select * from A
②A、B结构不一样:insert into B(col1,col2...) select A.col1,A.col2... from A where ...
③B不存在:select * into B from A