Recursive SQL

preview_player
Показать описание
Example of recursive SQL using Db2
Рекомендации по теме
Комментарии
Автор

Thanks sir, your video deserves more views and like.

foremost
Автор

Thank you! This has been a difficult concept to grasp but this video is what helped me finally understand it!

laxattack
Автор

thank you for explaining this....will be helpful for many

boseashish
Автор

could i do it with just N in the second table? not using N2 at all? will it ruin anything? i would just do:
with t(n) as
( select 1 from sysibm.sysdummy1
union all
select n+1 from t
where n<=10)
select n from t;

would it work just fine or is there any non-obvious for a person reason for putting n2?

cc-jfwp
Автор

when you say n <= 10 you don't need to provide a record? (for the catcher)

randlyce
welcome to shbcf.ru