SQL语句复习

最近要分析数据，不得不复习sql语句。。。。
忘了好多啊。。。。。。
学习参考：https://www.w3cschool.cn/sql/
1.sqlserver代码编辑器显示行数：打开 工具-----选项------文本编译器 ------所有语言------常规----行号

`
SELECT Country FROM Customers;

SELECT Distinct Country FROM Customers;

SELECT COUNT(Distinct Country) FROM Customers; 

SELECT *FROM Customers
WHERE Country='Mexico';

SELECT * FROM Customers
WHERE Country='Mexico' OR PostalCode='05021'

SELECT * FROM Customers
WHERE CustomerID=1

SELECT * FROM Customers
WHERE Country='Germany' 
AND City='Berlin' 


SELECT City,Region FROM Customers 
WHERE City='Berlin' OR City='München';

SELECT * FROM Customers
WHERE NOT Country='Germany';


SELECT * FROM Customers
WHERE Country='Germany' AND (City='berlin'or City='USA' );
--降序排序DESC 默认升序ASC
SELECT * FROM Customers
ORDER BY Country DESC;

--插入数据
INSERT INTO Customers(CustomerID ,CompanyName, ContactName, Address, City, PostalCode, Country) 
VALUES ('5','Cardinal','Tom B. Erichsen','Skagen 21','Stavanger','4006','Norway');

--使用一个表填充另一个表,这个有错误
INSERT INTO Custom