This report was prepared for the U.S. Department of Education under Contract No. EA96055001. The project monitor was Joanne Wiggins in the Planning and Evaluation Service. The views expressed herein are those of the contractor. No official endorseme
SQL常用语句最好用的 --在示例数据库Northwind中,执行数据查询,要求如下: use Northwind go --1、在”Suppliers”表中查询,得到不同的地区有多少家供应商的信息; select sum( SupplierID) 总数,Country 国家 from dbo.Suppliers group by Country --2、在”Suppliers”表中查询,显示哪些供应商有传真; select CompanyName 供应商 from dbo.Suppliers