選擇?Xm name,round((sysdate-csrq)/365,0) age from e其中xb = ' male
Select * from d其中lx= '技術服務中心';
select a.*,b.bmmc from (select dno,avg(money)江津from r group by dno)a left join(select bmmc,dno from d group by bmmc,dno) b on a.dno=b.dno order by a .江津desc
更新r集money = money-100 where money & gt;=600
更新r set money =(1+0.5)* money where dno in(select dno from d where bmmc = ' project three ')。
從d中刪除dno不在的地方(從r中選擇dno)?
從e a,d b,r c中選擇a.eno,a.xm,b.bmmc,c.money其中a.eno=c.eno,a.dno=c.dno
Select a. *,b . bmmc from(select dno from r where eno not in(select eno from e where XM = '張三三'))a.dno=b.dno上的左連接d b?
最後壹個自己寫,哈哈