2018
绉嬨�婃暟鎹簱鍘熺悊涓庡簲鐢ㄣ�嬭绋嬩綔涓氾紙瀹㈣绫诲瀷锛?/p>
鍗曢�夐
1
銆佷娇鐢ㄥ叧閿瓧
()
鍙互鎶婃煡璇㈢粨鏋滀腑鐨勯噸澶嶈灞忚斀銆?/p>
锛?/p>
2
鍒嗭級
A
锛?/p>
DISTINCT
B
锛?/p>
UNION
C
锛?/p>
ALL
D
锛?/p>
TOP
鎴戠殑绛旀锛?/p>
A
寰楀垎锛?/p>
2
鍒?/p>
2
銆?/p>
鍛戒护
SELECTs_no
锛?/p>
AVG(grade)AS鈥?/p>
骞冲潎鎴愮哗
鈥烣ROMscoreGROUPBYs_noHAV
INGAVG(grade)>=85
锛岃〃绀?/p>
()
銆?/p>
锛?/p>
2
鍒嗭級
A
锛庢煡鎵?/p>
score
琛ㄤ腑骞冲潎鎴愮哗鍦?/p>
85
鍒嗕互涓婄殑瀛︾敓鐨勫鍙峰拰骞冲潎鎴愮哗
B
锛庢煡鎵惧钩鍧囨垚缁╁湪
85
鍒嗕互涓婄殑瀛︾敓
C
锛庢煡鎵?/p>
score
琛ㄤ腑鍚勭鎴愮哗鍦?/p>
85
鍒嗕互涓婄殑瀛︾敓
D
锛庢煡鎵?/p>
score
琛ㄤ腑鍚勭鎴愮哗鍦?/p>
85
鍒嗕互涓婄殑瀛︾敓鐨勫鍙峰拰骞冲潎鎴愮哗
鎴戠殑绛旀锛?/p>
A
寰楀垎锛?/p>
2
鍒?/p>
3
銆?/p>
浣跨敤
()
韬唤楠岃瘉鏂瑰紡闇�瑕佸鎴风搴旂敤绋嬪簭杩炴帴鏃舵彁渚涚櫥褰曟椂闇�瑕佺殑鐢ㄦ埛鏍囪瘑鍜屽瘑
鐮併�?/p>
锛?/p>
2
鍒嗭級
A
锛?/p>
Windows
韬唤楠岃瘉
B
锛?/p>
SQLServer
韬唤楠岃瘉
C
锛庝互瓒呯骇鐢ㄦ埛韬唤鐧诲綍鏃?/p>
D
锛庡叾浠栨柟寮忕櫥褰曟椂
鎴戠殑绛旀锛?/p>
B
寰楀垎锛?/p>
2
鍒?/p>
4
銆佽〃杈惧紡
SUBSTRING(鈥濻HANGHAI鈥?6,3)
鐨勫�兼槸锛堬級銆?/p>
锛?/p>
2
鍒嗭級
A
锛?/p>
鈥橲HANGH鈥?/p>
B
锛?/p>
鈥橲HA鈥?/p>
C
锛?/p>
鈥橝NGH鈥?/p>
D
锛?/p>
鈥烪AI鈥?/p>
鎴戠殑绛旀锛?/p>
D
寰楀垎锛?/p>
2
鍒?/p>
5
銆佷笅闈㈠嚱鏁颁笉鑳借繘琛屾暟鎹被鍨嬭浆鎹㈢殑鏄細銆?/p>
锛?/p>
2
鍒嗭級