SQL笔试试题

SQL笔试试题

select ACCOUNT
,sum(RENT),sum().... from USERLIST a ,CHARGE b where a.TELEPHONE
=b.TELEPHONE(+)
group by a.ACCOUNT

上面是oracle用的
通用的是
select ACCOUNT
,sum(RENT),sum().... from USERLIST a left join CHARGE b on a.TELEPHONE
=b.TELEPHONE
group by a.ACCOUNT

select account,count(rent),sum(rent),nvl(sum(fee01),0),nvl(sum(fee02),0),nvl(sum(fee03),0),nvl(sum(fee04),0)
from USERLIST, CHARGE
and userlist.telephone=change.telephone(+)
group by account
order by 1;