Browse by Tags

All Tags » view (RSS)

CTE in a View

It is possible to use Common Table Expression in a View. But newbies wonder why the following is not possible create view numbers as with numbers ( n ) as ( select 1 as n union all select n + 1 from numbers where n < 10000 ) select n from numbers option...
Posted by Madhivanan | 3 comment(s)
Filed under: , , ,