factorial

From: Mikito Harakiri <mikharakiri_at_yahoo.com>
Date: 5 Jan 2002 20:25:15 -0800
Message-ID: <bdf69bdf.0201052025.78be07aa@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       

1. Is this going to work?
2. If not why, and what would be the correct recursive definition?

Received on Sat Jan 05 2002 - 22:25:15 CST