1.PIVOT和unPIVOT
2.update SET WHERE
3.DELETE FROM WHERE
4.TRUNCATE //删除数据表,释放内存和空间
5.All ,distinct//不重复的数据
6.ORDER BY
7.desc
8.like //模糊查询
9.And Or Not
10.stdev //偏差
11.HAVING //
12.join on
13.递归的CTE
2023-12-15 09:48:03
1.PIVOT和unPIVOT
2.update SET WHERE
3.DELETE FROM WHERE
4.TRUNCATE //删除数据表,释放内存和空间
5.All ,distinct//不重复的数据
6.ORDER BY
7.desc
8.like //模糊查询
9.And Or Not
10.stdev //偏差
11.HAVING //
12.join on
13.递归的CTE