SELECTDISTINCTCompany FROM Orders
SELECT * FROM PersonsWHERE City='Beijing'
SELECT * FROM Persons WHERE firstname='Thomas'ORlastname='Carter'
SELECT Company, OrderNumber FROM OrdersORDER BY Company, OrderNumber
INSERT INTO Persons VALUES ('Gates', 'Bill', 'Xuanwumen 10', 'Beijing')UPDATE Person SET FirstName = 'Fred' WHERE LastName = 'Wilson'
DELETE FROM Person WHERE LastName = 'Wilson'
SELECTTOP 2* FROM Persons
SELECT * FROM Persons
WHERE City LIKE '%lon%'
SELECT * FROM Persons
WHERE FirstName LIKE '_eorge'
SELECT * FROM Persons
WHERE LastName IN ('Adams','Carter')SELECT * FROM Persons
WHERE LastName
BETWEEN'Adams'AND'Carter'
SELECT po.OrderID, p.LastName, p.FirstName
FROM PersonsAS p, Product_OrdersAS po
WHERE p.LastName='Adams' AND p.FirstName='John'
SELECT Product_Orders.OrderID, Persons.LastName, Persons.FirstName
FROM Persons, Product_Orders
WHERE Persons.LastName='Adams' AND Persons.FirstName='John'
SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo
FROM Persons, Orders
WHERE Persons.Id_P = Orders.Id_P
SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo
FROM Persons
INNER JOIN Orders
ON Persons.Id_P=Orders.Id_P
ORDER BY Persons.LastName
SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo
FROM Persons
LEFT JOIN Orders
ON Persons.Id_P=Orders.Id_P
ORDER BY Persons.LastName
SELECT E_Name FROM Employees_China
UNION
SELECT E_Name FROM Employees_USA
SELECT INTO语句从一个表中选取数据，然后把数据插入另一个表中
SELECTLastName,FirstName
INTOPersons_backup
FROM Persons
CREATE DATABASE database_name
CREATE TABLE Persons
(
Id_P int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
)
CREATE INDEX PersonIndex
ON Person (LastName)
SELECT Customer,SUM(OrderPrice) FROM Orders
GROUP BY Customer
SELECT Customer,SUM(OrderPrice) FROM Orders
GROUP BY Customer
HAVING SUM(OrderPrice)<2000
SELECT Customer FROM Orders
WHERE OrderPrice>(SELECT AVG(OrderPrice) FROM Orders)
