当前位置: X题卡 > 所有题目 > 题目详情

查询有10名以上(含10名)职工的部门信息(部门名和职工人数),并按职工人数降序排列。 正确的命令是

查看本题答案

你可能感兴趣的试题

SELECT部门名,COUNT(职工号)AS职工人数;   FROM部门,职工WHERE部门.部门号=职工.部门号;   GROUP BY部门名HAVING COUNT(*)>=10;   ORDER BY COUNT(职工号)ASC  SELECT部门名,COUNT(职工号)AS职工人数;   FROM部门,职工WHERE部门.部门号=职工.部门号;   GROUP BY部门名HAVING COUNT(*)>=10;   ORDER BY COUNT(职工号)DESC  SELECT部门名,COUNT(职工号)AS职工人数;   FROM 部门,职工WHERE部门.部门号=职工.部门号;   GROUP BY 部门名HAVING COUNT(*)>=10;   ORDER BY 职工人数ASC  SELECT部门名,COUNT(职工号)AS职工人数;   FROM部门,职工WHERE部门.部门号=职工.部门号;   GROUP BY部门名 HAVING COUNT(*)>=10;   ORDER BY职工人数 DESC  
SELECT部门名,COUNT(职工号)AS职工人数;
FROM部门,职工WHERE部门.部门号-职工.部门号;
GROUP BY 部门名HAVING COUNT(*)>=10; ‘
ORDER BY COUNT(职工号)ASC  
SELECT部门名,COUNT(职工号)AS职工人数;
 FROM部门,职工WHERE部门.部门号=职工.部门号;
GROUPBY部门名HAVINGCOUNT(*)>=10;
ORDERBYCOUNT(职工号)DESC  
SELECT部门名,COUNT(职工号)AS职工人数;
FROM:部门,职工WHERE部门.部门号=职工.部门号;
GROUPBY部门名HAVINGCOUNT(*)>=10;
ORDERBY职工人数ASC  
SELECT部门名,COUNT(职工号)AS职工人数;
FROM 部门,职工WHERE部门.部门号=职工.部门号;
GROUP BY部门名HAVING COUNT(*)>=10; ’
ORDERBY职工人数DESC  
SELECT部门名,COUNT(职工号)AS职工人数;FROM部门,职工WHERE部门.部门号=职工.部门号;GROUP BY部门名HAVING COUNT(*)>=10;ORDER BY COUNT(职工号)ASC  SELECT部门名,COUNT(职工号)AS职工人数;FROM部门,职工WHERE部门.部门号=职工.部门号;GROUP BY部门名HAVING COUNT(*)>=10;ORDER BY COUNT(职工号)DESC  SELECT部门名,COUNT(职工号)AS职工人数;FROM 部门,职工WHERE部门.部门号=职工.部门号;GROUP BY 部门名HAVING COUNT(*)>=10;ORDER BY 职工人数ASC  SELECT部门名,COUNT(职工号)AS职工人数;FROM部门,职工WHERE部门.部门号=职工.部门号;GROUP BY部门名 HAVING COUNT(*)>=10;ORDER BY职工人数 DESC  
SELECT 部门名,COUNT(职工号) AS 职工人数;  FROM 部门,职工 WHERE 部门.部门号=职工.部门号;  GROUP BY 部门名 HAVING COUNT(*)>=10;  ORDER BY COUNT(职工号) ASC  SELECT 部门名,COUNT(职工号) AS 职工人数;  FROM 部门,职工 WHERE 部门.部门号=职工.部门号;  GROUP BY 部门名 HAVING COUNT(*)>=10;  ORDER BY COUNT(职工号) DESC  SELECT 部门名,COUNT(职工号) AS 职工人数;  FROM 部门,职工WHERE 部门,部门号=职工.部门号;  GROUP BY 部门名 HAVING COUNT(*)>=10  ORDER BY 职工人数 ASC  SELECT 部门名,COUNT(职工号) AS职工人数;  FROM部门,职工WHERE部门.部门号=职工.部门号;  
SELECT部门名,COUNT(职工号)AS职工人数; FDLOM部门,职工 WHERE部门.部门号=职工.部门号; OROUP BY部门名HAVING COUNT(*)>=10; ORDER BY COUNT(职工号)ASC  SELECT部门名,COUNT (职工号)AS职工人数; FROM部门,职工WHERE部门.部门号=职工.部门号; GROUP BY部门名HAVING COUNT(*)>=10; ORDER BY COUNT(职工号)DESC  SELECT部门名,COUNT(职工号)AS职工人数; PDLOM部门,职工WHERE部门.部门号=职工.部门号; OROUP BY部门名HAVING COUNT(*)>=10 ORDER BY职工人数ASC  SELECT部门名,COUNT(职工号)AS职工人数; FROM部门,职工WHERE部门.部门号=职工.部门号; GROUP BY部门名HAVING COUNT(*)>=10 ORDER BY职工人数DESC  
SELECT部门名,MIN(出生日期)FROM部门JOIN职工; ON部门.部门号=职工.部门号GROUP BY部门名  SELECT部门名,MAX(出生日期)FROM部门JOIN职工; ON部门.部门号=职工.部门号GROUP BY部门名  SELECT部门名,MIN(出生日期)FROM部门JOIN职工; WHERE部门.部门号=职工.部门号GROUP BY部门名  SELECT部门名,MAX(出生日期)FROM部门JOIN职工; WHERE部门.部门号=职工.部门号GROUP BY部门名  
SELECT部门名,COUNT(职工号)AS职工人数;
FDLOM部门,职工 WHERE部门.部门号=职工.部门号;
OROUP BY部门名HAVING COUNT(*)>=10;
ORDER BY COUNT(职工号)ASC  
SELECT部门名,COUNT (职工号)AS职工人数;
FROM部门,职工WHERE部门.部门号=职工.部门号;
GROUP BY部门名HAVING COUNT(*)>=10;
ORDER BY COUNT(职工号)DESC  
SELECT部门名,COUNT(职工号)AS职工人数;
PDLOM部门,职工WHERE部门.部门号=职工.部门号;
OROUP BY部门名HAVING COUNT(*)>=10
ORDER BY职工人数ASC  
SELECT部门名,COUNT(职工号)AS职工人数;
FROM部门,职工WHERE部门.部门号=职工.部门号;
GROUP BY部门名HAVING COUNT(*)>=10
ORDER BY职工人数DESC  
SELECT 部门名,COUNT(职工号) AS 职工人数;  FROM 部门,职工 WHERE 部门.部门号=职工.部门号;  GROUP BY 部门名 HAVING COUNT(*)>=10;  ORDER BY COUNT(职工号) ASC  SELECT 部门名,COUNT(职工号) AS 职工人数;  FROM 部门,职工 WHERE 部门.部门号=职工.部门号;  GROUP BY 部门名 HAVING COUNT(*)>=10;  ORDER BY COUNT(职工号) DESC  SELECT 部门名,COUNT(职工号) AS 职工人数;  FROM 部门,职工 WHERE 部门.部门号=职工.部门号;  GROUP BY 部门名 HAVING COUNT(*)>=10  ORDER BY 职工人数 ASC  SELECT 部门名,COUNT(职工号) AS 职工人数;  FROM 部门,职工 WHERE 部门.部门号=职工.部门号;  
SELECT部门名,COUNT(职工号)AS职工人数;   FROM部门,职工WHERE部门.部门号=职工.部门号;   GROUP BY部门名HAVING COUNT(*)>=10;   ORDER BY COUNT(职工号)ASC  SELECT部门名,COUNT(职工号)AS职工人数;   FROM部门,职工WHERE部门.部门号=职工.部门号;   GROUP BY部门名HAVING COUNT(*)>=10;   ORDER BY COUNT(职工号)DESC  SELECT部门名,COUNT(职工号)AS职工人数;   FROM 部门,职工WHERE部门.部门号=职工.部门号;   GROUP BY 部门名HAVING COUNT(*)>=10;   ORDER BY 职工人数ASC  SELECT部门名,COUNT(职工号)AS职工人数;   FROM部门,职工WHERE部门.部门号=职工.部门号;   GROUP BY部门名 HAVING COUNT(*)>=10;   ORDER BY职工人数 DESC  
SELECT部门名,MAX(出生日期)FROM部门JOIN职工; ON部门.部门号=职工.部门号GROUP BY部门名  SELECT部门名,MIN(出生日期)FROM部门JOIN职工;ON部门.部门号=职工.部门号GROUP BY部门名  SELECT部门名,MIN(出生日期)FROM部门JOIN职工; WHERE部门.部门号=职工.部门号GROUP BY部门名  SELECT部门名,MAX(出生日期)FROM部门JOIN职工;WHERE部门.部门号=职工.部门号GROUP BY部门名  
SELECT部门名,MIN(出生日期)FROM部门JOIN职工;   ON部门.部门号=职工.部门号GROUP BY部门名  SELECT部门名,MAX(出生日期)FROM部门JOIN职工;   ON部门.部门号=职工.部门号GROUP BY部门名  SELECT部门名,MIN(出生日期)FROM部门JOIN职工;   WHERE部门.部门号=职工.部门号GROUP BY部门名  SELECT部门名,MAX(出生日期)FROM部门JOIN职工;   WHERE部门.部门号=职工.部门号GROUP BY部门名  
SELECT部门名,MIN(出生日期)FROM部门JOIN职工;ON部门.部门号=职工.部门号GROUP BY部门名  SELECT部门名,MAX(出生日期)FROM部门JOIN职工;ON部门.部门号=职工.部门号GROUP BY部门名  SELECT部门名,MIN(出生日期)FROM部门JOIN职工;WHERE部门.部门号=职工.部门号GROUP BY部门名  SELECT部门名,MAX(出生日期)FROM部门JOIN职工;WHERE部门.部门号=职工.部门号GROUP BY部门名  
SELECT 部门名,COUNT(职工号)AS 职工人数;
FROM 部门,职工WHERE部门.部门号=职工.部门号;
GROUP BY 部门名 HAVING COUNT(*)>=10;
ORDER BY COUNT(职工号)ASC  
SEIECT 部门名,COUNT(职工号)AS职工人数;
FROM 部门,职工 WHERE 部门.部门号=职工.部门号;
GROUP BY 部门名 HAVING COUNT(*)>=10;
ORDER BY COUNT(职工号)DESC  
SELECT 部门名,COUNT(职工号)AS职工人数;
FROM 部门,职工 WHERE 部门.部门号=职工.部门号;
GROUP BY 部门名 HAVING COUNT(*)>=10;
ORDER BY 职工人数 ASC  
SELECT 部门名,COUNT(职工号)AS 职工人数;
FROM 部门,职工 WHERE部门.部门号;职工.部门号;
GROUP BY 部门名 HAVING COUNT(*)>=10;
ORDER BY 职工人数 DESC  
SELECT 部门名,COUNT (职工号)AS 职工人数; FROM 部门,职工 WHERE 部门. 部门号=职工.部门号; GROUP BY 部门名 HAVING COUNT(*)>=10; ORDER BY COUNT (职工号) ASC  SELECT 部门名,COUNT (职工号) AS 职工人数; FROM 部门,职工 WHERE 部门.部门号=职工.部门号; GROUP BY 部门名 HAVING COUNT(*)>=10; ORDER BY COUNT (职工号) DESC  SELECT 部门名,COUNT (职工号) AS 职工人数; FROM 部门,职工 WHERE 部门.部门号=职工.部门号; GROUP BY 部门名 HAVING COUNT(*)>=10; ORDER BY 职工人数 ASC  SELECT 部门名,COUNT(职工号) AS 职工人数; FROM 部门,职工 WHERE 部门. 部门号= 职工.部门号; GROUP BY 部门名 HAVING COUNT (*)>=10; ORDER BY 职工号人数 DESC  
SELECT部门名,COUNT(职工号)AS职工人数;FROM部门,职工WHERE部门.部门号=职工.部门号;GROUP BY部门名HAVING COUNT(*)>=10;ORDER BY COUNT(职工号)ASC  SELECT部门名,COUNT(职工号)AS职工人数;FROM部门,职工WHERE部门.部门号=职工.部门号;GROUP BY部门名HAVING COUNT(*)>=10;ORDER BY COUNT(职工号)DESC  SELECT部门名,COUNT(职工号)AS职工人数;FROM 部门,职工WHERE部门.部门号=职工.部门号;GROUP BY 部门名HAVING COUNT(*)>=10;ORDER BY 职工人数ASC  SELECT部门名,COUNT(职工号)AS职工人数;FROM部门,职工WHERE部门.部门号=职工.部门号;GROUP BY部门名 HAVING COUNT(*)>=10;ORDER BY职工人数 DESC  
SELECT部门名,COUNT(职工号)AS职工人数; FROM部门,职工WHERE部门.部门号=职工.部门号; GROUP BY部门名HAVING COUNT(*)>=10; ORDER BY COUNT(职工号)ASC  SELECT 部门名,COUNT(职工号)AS职工人数; FROM部门,职工WHERE 部门,部门号=职工.部门号; GROUP BY部门名HAVING COUNT(*)>=10; ORDER BY COUNT(职工号)DESC  SELECT部门名,COUNT(职工号)AS职工人数; FROM部门,职工WHERE正部门.部门号=职工.部门号; GROUP BY部门名HAVING COUNT(*)>=10 ORDER BY职工人数ASC  SELECT 部门名,COUNT(职工号)AS职工人数; FROM部门,职工WHERE部门.部门号=职工.部门号; GROUP BY部门名HAVING COUNT(*)>=10 ORDER BY职工人数DESC  
SELECT部门名,COUNT(职工号)AS职工人数;   FROM部门,职工WHERE部门.部门号=职工.部门号;   GROUP BY部门名HAVING COUNT(*)>=10;   ORDER BY COUNT(职工号)ASC  SELECT部门名,COUNT(职工号)AS职工人数;   FROM部门,职工WHERE部门.部门号=职工.部门号;   GROUP BY部门名HAVING COUNT(*)>=10;   ORDER BY COUNT(职工号)DESC  SELECT部门名,COUNT(职工号)AS职工人数;   FROM 部门,职工WHERE部门.部门号=职工.部门号;   GROUP BY 部门名HAVING COUNT(*)>=10;   ORDER BY 职工人数ASC  SELECT部门名,COUNT(职工号)AS职工人数;   FROM部门,职工WHERE部门.部门号=职工.部门号;   GROUP BY部门名 HAVING COUNT(*)>=10;   ORDER BY职工人数 DESC  
SELECT 部门名,COUNT(职工号)AS 职工人数; FROM 部门,职工WHERE部门.部门号=职工.部门号; GROUP BY 部门名 HAVING COUNT(*)>=10; ORDER BY COUNT(职工号)ASC  SEIECT 部门名,COUNT(职工号)AS职工人数; FROM 部门,职工 WHERE 部门.部门号=职工.部门号; GROUP BY 部门名 HAVING COUNT(*)>=10; ORDER BY COUNT(职工号)DESC  SELECT 部门名,COUNT(职工号)AS职工人数; FROM 部门,职工 WHERE 部门.部门号=职工.部门号; GROUP BY 部门名 HAVING COUNT(*)>=10; ORDER BY 职工人数 ASC  SELECT 部门名,COUNT(职工号)AS 职工人数; FROM 部门,职工 WHERE部门.部门号;职工.部门号; GROUP BY 部门名 HAVING COUNT(*)>=10; ORDER BY 职工人数 DESC  
SELECT部门名,COUNT(职工号)AS职工人数; FROM部门,职工WHERE部门.部门号-职工.部门号; GROUP BY 部门名HAVING COUNT(*)>=10; ‘ ORDER BY COUNT(职工号)ASC  SELECT部门名,COUNT(职工号)AS职工人数;  FROM部门,职工WHERE部门.部门号=职工.部门号; GROUPBY部门名HAVINGCOUNT(*)>=10; ORDERBYCOUNT(职工号)DESC  SELECT部门名,COUNT(职工号)AS职工人数; FROM:部门,职工WHERE部门.部门号=职工.部门号; GROUPBY部门名HAVINGCOUNT(*)>=10; ORDERBY职工人数ASC  SELECT部门名,COUNT(职工号)AS职工人数; FROM 部门,职工WHERE部门.部门号=职工.部门号; GROUP BY部门名HAVING COUNT(*)>=10; ’ ORDERBY职工人数DESC  
SELECT部门名,COUNT(职工号)AS职工人数;  FROM部门,职工WHERE部门.部门号-职工.部门号;  GROUP BY 部门名HAVING COUNT(*)>=10; ‘  ORDER BY COUNT(职工号)ASC  SELECT部门名,COUNT(职工号)AS职工人数;  FROM部门,职工WHERE部门.部门号=职工.部门号;  GROUPBY部门名HAVINGCOUNT(*)>=10;  ORDERBYCOUNT(职工号)DESC  SELECT部门名,COUNT(职工号)AS职工人数;  FROM:部门,职工WHERE部门.部门号=职工.部门号;  GROUPBY部门名HAVINGCOUNT(*)>=10;  ORDERBY职工人数ASC  SELECT部门名,COUNT(职工号)AS职工人数;  FROM 部门,职工WHERE部门.部门号=职工.部门号;  

热门试题

更多