题目内容

若需在zg表中按基本工资降序排列查询前三个的职工记录,下列语法正确的是 ()。

A. SELECT职工号,基本工资 TOP 3 FROM zg; ORDER BY 基本工资 DESC
B. SELECT职工号,基本工资 TOP 3 PERCENT FROM zg; ORDER BY 基本工资 DESC
C. SELECT职工号,基本工资 TOP 3 FROM zg DESC;
D. SELECT职工号,基本工资 TOP 3 PERCENTFROM zg DESC

查看答案
更多问题

若需统计zg表中车身厂的职工工资总和,下面语句正确的是()。

A. SELECT SUM(基本工资)FROM zg
B. SELECT SUM(基本工资)FROM zgWHERE 单位=“车身厂”
C. SELECT COUNT(基本工资)FROM zg
D. SELECT COUNT(基本工资)FROM zgWHERE单位=“车身厂”

Gun enthusiasts believe that ______.

A. teachers should carry guns to protect themselves.
B. gun carriers should be punished if they attempt to kill children.
C. it is too difficult for the teachers to obtain guns.
D. children should be protected by their teachers who carry guns.

According to Helen Smith, why did the men kill others before they commit suicide?

A. They want to take revenge on the society.
B. They want to vent their anger on others before they die.
C. They want companionship instead of loneliness when they die.
D. They want to satisfy their sexual desire before their death.

The best title for the text may be ______.

A. It's All About Me: Is the Boss an All-conquering Hero.
B. The Brand of Me: Does the Boss in Your Corporation Have Narcissism.
C. Narcissistic Boss: To Be Or Not To Be.
D. The Studies of Narcissism.

答案查题题库