sql server 2000

来自「JAVA下的SQL_System的建立」· 代码 · 共 29 行

--第十一章--查询分析器和事件探查器

--简单的查询语句
select * from member where rigion='北京' order by id desc

--在Orders表中查询employee ID 是 3的用户。查询语句如下：
SELECT CustomerID, EmployeeID, OrderID,OrderDate
FROM Orders
WHERE EmployeeID = 3

--在SELECT中使用hint：
SELECT CustomerID, EmployeeID, OrderID,OrderDate
FROM Orders Hint (INDEX(EmployeeID))
WHERE EmployeeID = 3

--一个join操作可以包含很多表的访问。下面是一个实例：
SELECT orderID,customerID,employees.EmployeeID,firstName,LastName,orderDate
FROM orders join employees on orders.EmployeeID = employees.EmployeeID

--上面的语句用来从表orders和employees中提取EmployeeID相同的纪录。用户也可以通过下面的语句实现同一种功能：
SELECT orderID,customerID,employees.EmployeeID,firstName,LastName,orderDate
FROM orders , employees where orders.EmployeeID=employees.EmployeeID

--下面的T-SQL语句不仅包含join操作，而且还包含一个aggregate操作：
SET QUOTED_IDENTIFIER ON
GO
SELECT CustomerID,SUM("Order Details".UnitPrice)
FROM Orders JOIN "Order Details" ON Orders.OrderID = "Order Details".OrderID
GROUP BY CustomerID