题目内容

使用下列数据表。部门 (部门号C(2)、部门名称C(10))职工 (部门号C(2)、职工号C(4)、姓名C(8)、基本工资N(7,2)) 检索最少有5名职工的每个部门的职工基本工资的总额( )。

A. SELECT 部门号,COUNT(),SUM(基本工资) FROM 职工; HAVING COUNT()＞=5
B. SELECT 部门号,COUNT(),SUM(基本工资) FROM 职工; GROUP BY 基本工资 HAVING COUNT()＞=5
C. SELECT 部门号,COUNT(),SUM(基本工资) FROM 职工; GROUP BY 部门号 HAVING COUNT()＞=5
D. SELECT 部门号,COUNT(),SUM(基本工资) FROM 职工; GROUP BY 部门号 WHERE COUNT()＞=5

查看答案

搜索结果不匹配？点我反馈

更多问题

Which of the following work is NOT written by John Milton

A. Paradise Lost
B. Paradise Regained
C. Julius Caesar
D. Samson Agonistes

The Age of William Shakespeare is also called the second period of____.

A. Elizabethan Period
B. Victorian Period
C. English Renaissance
D. James Period

Imagist poems are mainly composed in the form on____.

A. blank verse
B. free verse
C. sonnet
D. quatrain

Ralph Waldo Emerson"s____is regarded as the "Declaration of Intellectual Independence".

A. Nature
B. The Conduct of Life
C. Representative Men
D. The American Scholar