鍏崇郴鏁版嵁搴撴爣鍑嗚瑷�
SQL(
涓?/p>
)
(
鎬诲垎锛?/p>
88.00
锛屽仛棰樻椂闂达細
90
鍒嗛挓
)
涓�銆?/p>
(
鎬婚鏁帮細
35
锛屽垎鏁帮細
88.00)
1.
鏌ヨ鍗曚环鍦?/p>
600
鍏冧互涓婄殑涓绘満鏉垮拰纭洏鐨勬纭懡浠ゆ槸
______
銆?/p>
A) SELECT * FROM
浜у搧
WHERE
鍗曚环锛?/p>
600 AND(
鍚嶇О
='
涓绘満鏉?/p>
' AND
鍚嶇О
='
纭洏
')
B) SELECT * FROM
浜у搧
WHERE
鍗曚环锛?/p>
600 AND(
鍚嶇О
='
涓绘満鏉?/p>
' OR
鍚嶇О
='
纭洏
')
C) SELECT * FROM
浜у搧
FOR
鍗曚环锛?/p>
600 AND(
鍚嶇О
='
涓绘満鏉?/p>
' AND
鍚嶇О
='
纭洏
')
D) SELECT * FROM
浜у搧
FOR
鍗曚环锛?/p>
600 AND(
鍚嶇О
='
涓绘満鏉?/p>
' OR
鍚嶇О
='
纭洏
')
锛堝垎鏁帮細
2.00
锛?/p>
A.
B.
鈭?/p>
C.
D.
瑙ｆ瀽锛?/p>
[
瑙ｆ瀽
]
Visual
FoxPro
鐨?/p>
SQL
SELECT
鍛戒护鐨勮娉曟牸寮忎腑
WHERE
璇存槑鏌ヨ鏉′欢锛屽嵆閫夋嫨鍏冪粍鐨勬潯浠躲�?/p>
閫昏緫杩愮畻
AND
琛ㄧず鈥滃拰鈥濄�傛晠鏈閫夐」
B
姝ｇ‘銆?/p>
2.鈥滄暀甯堣〃鈥濅腑鏈夆�滆亴宸ュ彿鈥濄�佲�滃鍚嶁�濆拰鈥滃伐榫勨�濆瓧娈碉紝鍏朵腑鈥滆亴宸ュ彿鈥濅负涓诲叧閿瓧锛屽缓绔嬧�滄暀甯堣〃鈥?/p>
鐨?/p>
SQL
鍛戒护鏄?/p>
______
銆?/p>
A) CREATE TABLE
鏁欏笀琛?/p>
(
鑱屽伐鍙?/p>
C(10)PRIMARY
锛屽鍚?/p>
C(20)
锛屽伐榫?/p>
I)
B) CREATE TABLE
鏁欏笀琛?/p>
(
鑱屽伐鍙?/p>
C(10)FOREING
锛屽鍚?/p>
C(20)
锛屽伐榫?/p>
I)
C) CREATE TABLE
鏁欏笀琛?/p>
(
鑱屽伐鍙?/p>
C(10)FOREING KEY
锛屽鍚?/p>
C(20)
锛屽伐榫?/p>
I)
D) CREATE TABLE
鏁欏笀琛?/p>
(
鑱屽伐鍙?/p>
C(10)PRIMARY KEY
锛屽鍚?/p>
C(20)
锛屽伐榫?/p>
I)
锛堝垎鏁帮細
2.00
锛?/p>
A.
B.
C.
D.
鈭?/p>
瑙ｆ瀽锛?/p>
[
瑙ｆ瀽
]
鍏抽敭瀛楃殑璁剧疆搴旇浣跨敤
PRIMARY
KEY
銆?/p>
PRIMARY
KEY
鍒楃害鏉熻〃鏄庤〃涓殑涓�涓垪
/
瀛楁鍙兘鍖呭惈
鍞竴鐨?/p>
(
涓嶉噸澶?/p>
)
銆?/p>
闈炵┖鐨勬暟鍊笺�?/p>
鍦ㄨ鍒?/p>
/
瀛楁鐨?/p>
PRIMARY
KEY
绾︽潫瀹氫箟涓笉闇�瑕佹樉寮忓湴鍖呮嫭
NOT
NULL
绾︽潫銆?/p>
涓�涓〃鍙兘澹版槑涓�涓?/p>
PRIMARY KEY
銆?/p>
3.
鍦?/p>
SQL
鐨?/p>
SELECT
鏌ヨ涓紝
HAVING
瀛愬彞涓嶅彲浠ュ崟鐙娇鐢紝鎬绘槸璺熷湪
1
瀛愬彞涔嬪悗涓�璧蜂娇鐢ㄣ�?/p>
锛堝垎鏁帮細
2.00
锛?/p>
濉┖椤?/p>
1:__________________
锛堟纭瓟妗堬細
GROUP BY
锛?/p>
瑙ｆ瀽锛?/p>
[
瑙ｆ瀽
] HAVING
瀛愬彞蹇呴』璺熼殢
GROUP BY
浣跨敤锛屽畠鐢ㄦ潵闄愬畾鍒嗙粍蹇呴』婊¤冻鐨勬潯浠躲�?/p>
浣跨敤濡備笅鏁版嵁琛細
瀛︾敓
.DBF
锛氬鍙?/p>
(C
锛?/p>
8)
銆佸鍚?/p>
(C
锛?/p>
6)
銆佹�у埆
(C
锛?/p>
2)
銆佸嚭鐢熸棩鏈?/p>
(D)
閫夎
.DBF
锛氬鍙?/p>
(C
锛?/p>
8)
銆佽绋嬪彿
(C
锛?/p>
3)
銆佹垚缁?/p>
(N
锛?/p>
5
锛?/p>
1)
锛堝垎鏁帮細
12.00
锛?/p>