SQL期末考试题，来个大神帮解答一下

select fph from mz_brsf

whereje > 200;

2select sum(je) from mz_brsf

where sfsj >=  '2012-01-01'

and sfsj < '2012-02-01';

3delete from mz_bfsf

where cfh is null;

4update mz_bfsf

set substr(sfsj,1,4) =2013

where ks ='内科' ;

5 select ks, sum(je) from mz_bfsf

group by ks

having sum(je) >500;

6select top 2 ys,sum(je)

from mz_bfsf

group by ys

order by sum(je) desc;

7update  a

set azc = bzc

from mz_bfsf a,mz_brxx b

where  ays = bys

真题网>

以上就是关于SQL期末考试题，来个大神帮解答一下全部的内容，包括:SQL期末考试题，来个大神帮解答一下、数据库技术试题、等相关内容解答，如果想了解更多相关内容，可以关注我们，你们的支持是我们更新的动力！