銆婃暟鎹簱鍘熺悊銆嬪疄楠屾姤鍛?/p>
棰樼洰锛?/p>
瀹為獙鍥?/p>
:
瑙嗗浘涓庣储寮?/p>
瀛﹀彿
濮撳悕
鐝骇
鏃ユ湡
2014302692
瀛熺帀鍐?/p>
10011402
16.10.18
涓�
.
瀹為獙鍐呭銆佹楠や互鍙婄粨鏋?/p>
1
锛?/p>
鍦?/p>
Student
鏁版嵁搴撲腑锛屽埄鐢ㄥ浘褰㈢敤鎴风晫闈紝鍒涘缓涓�涓�変慨浜嗏�滄暟鎹簱鍘熺悊鈥濊绋嬪苟涓?
鏄?/p>
1996
骞村嚭鐢熺殑瀛︾敓鐨勮鍥撅紝瑙嗗浘涓寘鎷鍙凤紝鎬у埆锛屾垚缁╀笁涓俊鎭�?/p>
(5
鍒?/p>
)
2
锛?/p>
鐢ㄤ袱绉嶄笉鍚岀殑
SQL
璇彞鍒涘缓绗簲鐗堟暀鏉愮涓夌珷
绗?/p>
9
棰樹腑瑕佹眰鐨勮鍥?/p>
锛堣鍥惧悕锛?/p>
V_SPJ
锛?
锛?/p>
10
鍒嗭紝姣忕鏂规硶
5
鍒?/p>
)
銆?/p>
1).
create view v_spj
as
select sno,pno,qty
from J,SPJ
where j.jno=spj.jno and jname='
涓夊缓
'
2).
create view view_2
as
select sno,pno,qty
from SPJ
where jno =(select jno from j
where jname ='
涓夊缓
')
3
锛?/p>
鐢?/p>
SQL
璇彞瀹屾垚绗簲鐗堟暀鏉愮涓夌珷
绗?/p>
9
棰樹腑鐨勮鍥炬煡璇紙
10
鍒嗭紝姣忓皬棰?/p>
5
鍒?/p>
)
銆?/p>
1).
select pno,sum(qty) as sum_qty
from v_spj
group by pno
缁撴灉
: