软件测试笔试题

--5)查询购买了产品编号“P0002”的客户编号、客户名和电话，
--查询结果按客户名降序排列。

--子查询

select CusNo, CusName, Tel
  from Customer
 where CusNo in (select CusNo from ProOut where ProNo = 'P0002')
 order by CusName desc;

--內连

select c.CusNo, c.CusName, c.Tel
  from ProOut p
 inner join Customer c
    on c.cusno = p.cusno
 where P.Prono = 'P0002'
 order by c.CusName desc;

解析：Result=foo(4)+foo(3)
foo(4)=foo(3)+foo(2)
foo(3)=foo(2)+foo(1)
foo(2)=foo(1)+foo(0)
foo(1)=1
foo(0)=0
所以foo(2)=1,foo(3)=2,foo(4)=3