题目内容

到(35)题使用如下数据表。
“班级”表：
班级号班级名
11 信息200801班
12 信息200802班
21 计算机200801班
22 计算机200802班
“教师”表：
教师编号姓名班级号工资职称电话
T11 李清 11 1500.00 讲师 65854587
T22 王晓黎 12 2200.00 教授 63525876
T33 欧倩倩 11 16
若有如下SQL语句： SELECT姓名,MIN(工资)FROM教师GROUP BY班级号执行该语句后，查询结果共显示()条记录。

A. 0
B. 1
C. 4
D. 7

查看答案

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

更多问题

若有如下SQL语句 SELECT DISTINCT工资FROM教师； WHERE工资=(SELECT MAX(工资)FROM教师)； INTO TABLE Result 执行该语句后，Result表中的记录个数是()。

A. 1
B. 2
C. 3
D. 4

As he closed his service station at 1:20 one Sunday morning, Tony Payseur set on the ground a metal cash box containing $7000. At home a short while later, he reached in the back of his car for the box. It was missing.
Realizing that he must have left it outside the station, Payseur speeded back. The box was gone. Sunday morning; although he felt iii, Payseur went to work with his two sons. Then, in the middle of the afternoon, a man named Wayne came and told his story. Passing the station minutes after Payseur left the previous night, Brazzell had spotted the metal box. Thinking it was a tool-box someone had left accidentally, he stopped and picked it up. About 3 p. m. Sunday, Brazzell opened the box. Finding it filled with cash, he rushed to the station.
"I couldn' t believe someone would be so honest," Payseur said it when he got back his box.
What is the passage mainly about？

A. How the missing metal box was returned.
B. Mr. Payseur is a lucky man.
C. Mr. Payreur' s metal box.
D. Mr. Payseur' s carelessness.

A．satisfyB．satisfiedC．satisfyingD．to satisfy

A. satisfy
B. satisfied
C. satisfying
D. to satisfy

A．For the same reasonB．For that purposeC．As a resultD．On the contrary

A. For the same reason
B. For that purpose
C. As a result
D. On the contrary