NorthWind 数据库
浏览数：31 /
时间：2015年06月12日
NorthWind 数据库
- Categories:产品类别；
- Customers：客户；
- Employees:雇员
- Employees Territories:员工涉及领域
- Order Details：订单明细
- Orders：订单
- Products：产品
- Region：地区
- Shippers：运货商
- Suppliers：供应商
- Territories：地域
在NorthWind数据库中创建关系图：
下面进行几次查询了解数据内容：
select productid,productname,unitprice from Products where UnitPrice>49
查询结果：
select productid,productname,UnitsInStock,UnitsOnOrder from Products where UnitsInStock<UnitsOnOrder查询结果：
select * from Products where ProductName='Aniseed Syrup' or ProductName='Ipoh Coffee'
select * from Products
where ProductName in('Aniseed Syrup','Ipoh Coffee')
查询结果：
select * from Products where SupplierID=CategoryID查询结果：
select SupplierID,CompanyName,Phone,Fax from Suppliers where Phone is not null and fax is null
select * from Suppliers order by City desc
select SupplierID,CompanyName,Country from Suppliers
where Country in('USA','UK','Germany')
select SupplierID,CompanyName,ContactTitle,Phone from Suppliers where ContactTitle='Marketing Manager' and Phone is not null
select distinct ShipVia from Orders
select distinct ShipCity from Orders
select OrderID,ShippedDate,RequiredDate from Orders where ShippedDate>RequiredDate
select OrderID,CustomerID,Freight from Orders where Freight<55
select * from Categories where CategoryName like '_e%'
select * from Categories where Description like '%sweet%'
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
