鏁版嵁搴撲腑鏈夊涓嬩笁涓〃锛?/p>
瀛︾敓琛紙瀛﹀彿
id
锛屽鍚?/p>
name
锛屾�у埆
sex
锛岀郴閮?/p>
depart
锛屽勾榫?/p>
age
锛?/p>
8
涓鐢熻褰?/p>
閫夎琛紙瀛﹀彿
id
锛岃绋嬪彿
cid
锛屾垚缁?/p>
grade
锛?/p>
12
闂ㄨ绋?/p>
璇剧▼琛紙璇剧▼鍙?/p>
cid
锛岃绋嬪悕
cname
锛屽鍒?/p>
Ccredit
锛?/p>
6
闂ㄨ绋?/p>
瀛︾敓
-
璇剧▼妯″紡
S-T :
瀛︾敓琛細
Student(Sno,Sname,Ssex,Sage,Sdept)
璇剧▼琛細
Course(Cno,Cname,Cpno,Ccredit)
瀛︾敓閫夎琛細
SC(Sno,Cno,Grade)
1.
浠庡鐢熻〃涓煡璇㈡墍鏈夊悓瀛︾殑鎵�鏈変俊鎭?/p>
select
*
from
瀛︾敓琛?/p>
2.
浠庡鐢熻〃涓煡璇㈡墍鏈夊鐢熺殑淇℃伅锛屽苟鍒嗗埆璧嬩簣涓�涓埆鍚?/p>
select
瀛﹀彿
as
xuehao
,
濮撳悕
as
xingming
,
鎬у埆
as
xingbie
,
绯婚儴
as
xibu
,
骞撮緞
as
nianling
from
瀛︾敓琛?/p>
3.
浠庡鐢熻〃涓煡璇㈠鍚嶆槸
Allen
鐨勫鐢熺殑淇℃伅
select
*
from
瀛︾敓琛?/p>
where
濮撳悕
=
'Allen'
4.
浠庡鐢熻〃涓煡璇?/p>
瀛﹀彿鍦?/p>
1101
鍒?/p>
1199
涔嬮棿鐨勬墍鏈夊鐢熺殑淇℃伅
select
*
from
瀛︾敓琛?/p>
where
瀛﹀彿
between
1101
and
1199
5.
浠庡鐢熻〃涓煡璇㈠勾榫勫皬浜?/p>
18
鍜屽ぇ浜?/p>
20
鐨勬墍鏈夊鐢熺殑瀛﹀彿鍜屽鍚?/p>
select
瀛﹀彿
,
濮撳悕
from
瀛︾敓琛?/p>
where
骞撮緞
<
18
or
骞撮緞
>
20
6.
浠庡鐢熻〃涓煡璇㈣绠楁満绯诲勾榫勫皬浜?/p>
20
鐨勬墍鏈夊鐢熺殑淇℃伅
select
*
from
瀛︾敓琛?/p>
where
绯婚儴
=
'computer'
and
骞撮緞
<
20
7.
浠庡鐢熻〃涓煡璇㈠鍚嶄互
A
寮�澶寸殑瀛︾敓鐨勪俊鎭?/p>
select
*
from
瀛︾敓琛?/p>
where
濮撳悕
LIKE
'A%'
8.
浠庡鐢熻〃涓煡璇㈠鍚嶇殑绗笁涓瓧绗︽槸
A
鐨勫鐢熺殑瀛﹀彿鍜屽鍚?/p>
select
瀛﹀彿
,
濮撳悕
from
瀛︾敓琛?/p>
where
濮撳悕
LIKE
'__A%'
9.
浠庡鐢熻〃涓煡璇㈠鍚嶄腑鍖呭惈鈥?/p>
llen
鈥濈殑瀛︾敓鐨勫鍙峰拰濮撳悕
select
瀛﹀彿
,
濮撳悕
from
瀛︾敓琛?/p>
where
濮撳悕
LIKE
'%llen%'
10.
浠庡鐢熻〃涓煡璇㈠鍚嶄腑鍖呭惈鈥?/p>
llen
鈥濅笖濮撳悕鍙湁
5
涓瓧绗︾殑瀛︾敓鐨勫鍙峰拰濮撳悕