公司有一个客户的数据表,此表的建立语句如下: CREATE TABLE Customers (CustomerID int NOT NULL, CustomerName varchar(50) NOT NULL, ContactName varchar(30) NULL, Phone varchar(20) NULL, Country varchar(30) NOT NULL, CONSTRAINT PK_Customers PRIMARY KEY(CustomerID) ) 大部分的国家或地区只包含2-3个客户,而一些国家包括多于20个客户。现在公司想对客户数量在10(含10)个以上的国家进行广告宣传,你使用( )语句将这些国家列出。
A.
SELECT Country FROM Customers GROUP BY Country HAVING COUNT (Country)>=10
B.
SELECT TOP 10 Country FROM Customers
C.
SELECT TOP 10 Country FROM Customers FROM (SELECT DISTINCT Country FROM Customers) AS X GROUP BY Country HAVING COUNT(*)>= 10
D.
SET ROWCOUNT 10 SELECT Country, COUNT (*) as “NumCountries” FROM Customers GROUP BY Country ORDER BY NumCountries, Desc