NorthWind 数据库

Categories:产品类别；Customers：客户；Employees:雇员Employees Territories:员工涉及领域Order Details：订单明细Orders：订单Products：产品Region：地区Shippers：运货商Suppliers：供应商TerritZ??http://www.2cto.com/kf/ware/vc/" target="_blank" class="keylink">vcmllc6O6tdjT8goKICAgICAgICDU2k5vcnRoV2luZMr9vt2/4tbQtLS9qLnYz7XNvKO6CjxpbWcgc3JjPQ=="https://www.cppentry.com/upload_files/article/57/1_qsdc4__.jpg" alt="\">
下面进行几次查询了解数据内容：

select productid,productname,unitprice from Products
where UnitPrice>49

查询结果：

select productid,productname,UnitsInStock,UnitsOnOrder
 from Products where UnitsInStock查询结果： 
 
 
 
 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%'

NorthWind数据库

NorthWind 数据库