未分类题

有SQL语句： SELECTDISTINCT系号FROM教师WHERE工资>=； ALL(SELECT工资FROM教师WHERE系号='02') 与如上语句等价的SQL语句是
A.SELECTDISTINCT系号FROM教师WHERE工资>=； (SELECTMAX(工资)FROM教师WHERE系号='02')
B.SELECTDISTINCT系号FROM教师WHERE工资>=； (SELECTMIN(工资)FROM教师WHERE系号='02')
C.ELECTDISTINCT系号FROM教师WHERE工资>=； ANY(SELECT工资FROM教师WHERE系号='02')
D.SELECTDISTINCT系号FROM教师WHERE工资>=； SOME(SELECT工资FROM教师WHERE系号='02')

A.SELECTDISTINCT系号FROM教师WHERE工资>=；
B.SELECTDISTINCT系号FROM教师WHERE工资>=；
C.ELECTDISTINCT系号FROM教师WHERE工资>=；
D.SELECTDISTINCT系号FROM教师WHERE工资>=；

【参考答案】

A
解析：本题SQL语句的含义是检索有教师工资大于或等于系号为“02”的所有教师工资的系号。ALL、ANY和SO......

(↓↓↓ 点击下方‘点击查看答案’看完整答案 ↓↓↓)

<上一题目录下一题>

热门试题

未分类题

假定用户名和口令存储在自由表“口令表”中，当用户输入用户名和口令并单击“登录”按钮时，若用户名输入错误，则提示“用户名错误”；若用户名输入正确，而口令输入错误，则提示“口令错误”。若命令按钮“登录”的Click事件中的代码如下： USE口令表 GO TOP flag=0 DO WHILE.not．EOF() IF Alltrim(用户名)==Alltrim(Thisform．Text1．Value) IF Alltrim(口令)==Alltrim(Thisform．Text2．Value) WAIT'欢迎使用”WINDOW TIMEOUT2 ELSE WAIT“口令错误”WINDOW TIMEOUT2 ENDIF flag=1 EXIT ENDIF SKIP ENDDO IF________ WAIT“用户名错误”WINDOW TIMEOUT 2 ENDIF 则在横线处应填写的代码是A.flag=-1B.flag=0C.flag=1D.flag=2

A.not．EOF()
B.Text1．Value)
C.Text2．Value)
D.flag=-1
B.flag=0
C.flag=1

未分类题

Mr Duffy raised his eyes from the paper and gazed out of his window on the cheerless evening landscapE.The river lay quiet beside the empty distillery and from time to time a light appeared in some house on Lucan RoaD.What an end! The whole narrative of her death revolted him and it revolted him to think that he had ever spoken to her of what he held sacreD.The cautious words of a reporter won over to conceal the details of a commonplace vulgar death attacked his stomach. Not merely had she degraded herself, she had degraded him. His soul's companion! He thought of the hobbling wretches whom he had seen carrying cans and bottles to be filled by the barman. Just God, what an end! Evidently she had been unfit to live, without any strength of purpose, an easy prey to habits, one of the wrecks on which civilization has been reareD.But that she could have sunk so low! Was it possible he had deceived himself so utterly about her? He remembered her outburst of that night and interpreted it in a harsher sense than he had ever donE.He had no difficulty now in approving of the course he had taken.As the light failed and his memory began to wander he thought her hand touched his. The shock which had first attacked his stomach was now attacking his nerves. He put on his overcoat and hat quickly and went out. The cold air met him on the threshold; it crept into the sleeves of his coat. When he came to the public-house at Chapel Bridge he went in and ordered a hot punch.The proprietor served him obsequiously but did not venture to talk. There were five or six working-men in the shop discussing the value of a gentleman's estate in County KildarE.They drank at intervals from their huge pint tumblers, and smoked, spitting often on the floor and sometimes dragging the sawdust over their heavy boots. Mr Duffy sat on his stool and gazed at them, without seeing or hearing them. After a while they went out and he called for another punch. He sat a long time over it. The shop was very quiet. The proprietor sprawled on the counter reading the newspaper and yawning. Now and again a tram was heard swishing along the lonely road outsidE.As he sat there, living over his life with her and evoking alternately the two images on which he now conceived her, he realized that she was dead, that she had ceased to exist, that she had become a memory. He began to feel ill at easE.He asked himself what else could he have donE.He could not have lived with her openly. He had done what seemed to him best. How was he to blame? Now that she was gone he understood how lonely her life must have been, sitting night after night alone in that room. His life would be lonely too until he, too, died, ceased to exist, became a memory--if anyone remembered him.Mr Duffy's immediate reaction to the report of the woman's death was that of______.A.disgustB.guiltC.griefD.compassion

A.B.
C.
D.
Mr
E.
A.disgust
B.guilt
C.grief