Pascal's triangle or binomial coefficients
146850Nov 14 2005 — edited May 3 2008<font color="red">you know Pascal's triangle like below.</font>
1
11
121
1331
14641
...
...
my question is to find out a query giving nth sequence,
that is to say,
when n=1, that query yields
1
when n=2
1
1
when n=3
1
2
1
when n=4
1
3
3
1
...
...
(oh, but you have NOT to use any subqueries)
for more SQL problems & questions, please visit
http://cafe.daum.net/oraclesqltuning