factorial
From: Mikito Harakiri <mikharakiri_at_yahoo.com>
Date: 5 Jan 2002 20:25:15 -0800
Message-ID: <bdf69bdf.0201052025.78be07aa_at_posting.google.com>
WITH
factorial AS (
Date: 5 Jan 2002 20:25:15 -0800
Message-ID: <bdf69bdf.0201052025.78be07aa_at_posting.google.com>
WITH
factorial AS (
select n+1, f*(n+1) from factorial union select 1, 1 from table(values(1,1)) )SELECT f FROM factorial
WHERE n=5
- Is this going to work?
- If not why, and what would be the correct recursive definition?