在池塘边,榕树下,张三看到了3个头8条腿,有几只鸡,几头牛,查询得到下面数据
/*二次一元方程:
niu +ji = 3
niu*4 +ji*2 =8;
niu :[0,10]
ji:[0,10]
*/
-牛表
select rownum niu from emp where rownum <=10;
--鸡表
select rownum ji from emp where rownum <=10;
select niu "牛",ji "鸡"
from (select rownum niu from emp where rownum<=10),
(select rownum ji from emp where rownum<=10) where
niu+ji =3 and niu * 4+ji*2 =8;