涓ぇ缃戞牎寮曢鎴愬姛鑱屼笟浜虹敓
涓ぇ缃戞牎
鈥?/p>
鍗佷匠缃戠粶鏁欒偛鏈烘瀯
鈥?/p>
銆?/p>
鈥?/p>
鍗佷匠鑱屼笟鍩硅鏈烘瀯
鈥?/p>
缃戝潃锛?/p>
www.wangxiao.cn
鍏ㄥ浗璁＄畻鏈虹瓑绾ц�冭瘯浜岀骇
VF
绗旇瘯妯℃嫙璇曢
(9)
鎬诲垎锛?/p>
100
鍒?/p>
鍙婃牸锛?/p>
60
鍒?/p>
鑰冭瘯鏃堕棿锛?/p>
90
鍒?/p>
姣忓皬棰?/p>
2
鍒嗭紝鍏?/p>
70
鍒?/p>
(1)
鏈夊涓?/p>
SQL
璇彞锛?/p>
SELECT
浣跨敤閮ㄩ棬锛?/p>
SUM
锛堝崟浠?/p>
*
璁惧鏁伴噺锛?/p>
AS
鎬婚噾棰?/p>
FROM
璁惧琛紱
WHERE
.NOT.
锛堣繘鍙ｏ級
锛?/p>
GROUP
BY
浣跨敤閮ㄩ棬
鎵ц璇ヨ鍙ュ悗锛岀涓�
鏉¤褰曠殑
"
鎬婚噾棰?/p>
"
瀛楁鍊兼槸
A. 196000.00
B. 143000.00
C. 294000.00
D. 17200.00
(2)
灏?/p>
E-R
鍥捐浆鎹㈠埌鍏崇郴妯″紡鏃讹紝瀹炰綋涓庤仈绯婚兘鍙互琛ㄧず鎴?/p>
A.
灞炴�?/p>
B.
鍏崇郴
C.
閿?/p>
D.
鍩?/p>
(3)
鏌ヨ璁捐鍣ㄤ腑鐨?/p>
"
绛涢�?/p>
"
閫夐」鍗＄殑浣滅敤鏄紙
锛?/p>
銆?/p>
A.
澧炲姞鎴栧垹闄ゆ煡璇㈣〃
B.
鏌ョ湅鐢熸垚鐨?/p>
SQL
浠ｇ爜
C.
鎸囧畾鏌ヨ璁板綍鐨勬潯浠?/p>
D.
閫夋嫨鏌ヨ缁撴灉鐨勫瓧娈佃緭鍑?/p>
(4)
涓嬪垪鍑芥暟涓紝鍑芥暟鍊间负鏁板�煎瀷鐨勬槸锛?/p>
锛?/p>
銆?/p>
A. DA
TE
锛堬級
B. TIME
锛堬級
C. YEAR
锛堬級
D. DA
TETIME
锛堬級
(5)
宸茬煡涓�妫典簩鍙夋爲鍓嶅簭閬嶅巻鍜屼腑搴忛亶鍘嗗垎鍒负
ABDEGCFH
鍜?/p>
DBGEACHF
锛?/p>
鍒欒浜屽弶鏍戠殑
鍚庡簭閬嶅巻涓?/p>
A. GEDHFBCA
B. DGEBHFCA
C. ABCDEFGH
D. ACBFEDHG