题目内容
（请给出正确答案）
提问人：网友lixin080108
发布时间：2022-01-07
[主观题]
公司有一个客户的数据表，此表的建立语句如下：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
公司有一个客户的数据表，此表的建立语句如下：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
A、SELECT Country FROM CustomersGROUP 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 XGROUP BY Country HAVING COUNT(*)>= 10
D、SET ROWCOUNT 10SELECT Country, COUNT (*) as “NumCountries”FROM CustomersGROUP BY Country ORDER BY NumCountries, Desc
简答题官方参考答案
（由简答题聘请的专业题库老师提供的解答）
查看官方参考答案
