ÇóÒ»sqlÓï¾ä - Oracle / ¿ª·¢

Á½¸ö±í

Çë¿´ "Persons" ±í£º
name banji shunxu
yiyang 01 1
yiyang 02 1
lili 01 2
  
½ÓÏÂÀ´Çë¿´ "xueke" ±í£º

name kemu shunxu
yiyang 01-yingyu 1
yiyang 01-shuxue 1
yiyang 02-yingyu 1
lili 01-yuwen 2

µÚÒ»¸ö±íÿ¸öѧÉúÓÐÁ½Ìõ¼Ç¼£¬Ò²¿ÉÄÜÒ»Ìõ£¬µÚ¶þ¸ö±í¾ÍÓжà¸ö¼Ç¼ÓëÖ®¶ÔÓ¦
ÎÒÏÖÔÚÏëÈ¡³öµÚÒ»¸ö±íÖеÄÐÕÃû£¬µÚ¶þ¸ö±íÖÐËùÓеļǼ£¬Èç¹ûÓÃjoin¾Ídouble¼Ç¼ÁË¡£

select a.name,b.kemu from persons a,xueke b where a.name = b.name order by shunxu
ÕâÑù¼Ç¼¾ÍË«±¶¡£ÓÃunionµÄ»°²»ÄܺÍorder byͬʱʹÓã¬Çë´ó¼Ò°ïæ

---

order by¿ÉÒԷŵ½×îºó»òÕß¼ÓÒ»¸ö×Ó²éѯ°¡..

---

select a.name,b.kemu,B.SHUNXU 
from (SELECT DISTINCT NAME from persons ) a,
xueke b 
where a.name = b.name 
order by B.shunxu

---

xueke±íÀï±¾Éí¾ÍÓÐnameÁË£¬Ó¦¸ÃÖ»ÊǶÔÕÕ¿´±ípersonsÀïÊÇ·ñÓмǼ°É..

SQL code:
SELECT NAME, kemu, shunxu
from xueke a
WHERE EXISTS (SELECT '*'
from persons b
WHERE b.NAME = a.NAME)

---

select * from (select a.name,b.kemu from persons a,xueke b where a.banji='01' and a.name =b.name order by a.shenxu) from a 
union
select * from (select a.name,b.kemu from persons a,xueke b where a.ba