{"id":160,"date":"2023-05-18T11:55:12","date_gmt":"2023-05-18T11:55:12","guid":{"rendered":"https:\/\/datadandies.nl\/?p=160"},"modified":"2023-05-18T11:55:12","modified_gmt":"2023-05-18T11:55:12","slug":"recursive-query-voor-compound-interest-in-sql","status":"publish","type":"post","link":"https:\/\/datadandies.nl\/index.php\/2023\/05\/18\/recursive-query-voor-compound-interest-in-sql\/","title":{"rendered":"Recursive query voor compound interest in SQL"},"content":{"rendered":"\n<p>Wil je samengestelde rente, ofwel compound interest berekenen in T-SQL?&nbsp;<\/p>\n\n\n\n<p>Dit kan m.b.v. een recursive query.<\/p>\n\n\n\n<p>Een recursive query is een \u201cloop\u201d, oftewel, een query die zichzelf blijft herhalen. De syntax is relatief eenvoudig; in de onderstaande voorbeeld-query in T-SQL zeg je:\u00a0\u00a0<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Pak het startbedrag van in dit geval 100&#8230; (startpunt)&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Vermenigvuldig dit voor elke nieuwe regel met 1,05&#8230; (recursive onderdeel)&nbsp;<\/li>\n\n\n\n<li>Tot ik zeg dat dit niet meer hoeft. (be\u00ebindigingsvoorwaarde van de loop)&nbsp;<\/li>\n<\/ul>\n\n\n\n<p>Je kunt in dergelijke berekeningen ook rekening houden met verschillende rentepercentages per jaar. Nog een manier om samengestelde rente te berekenen is m.b.v. window functies i.p.v. een recursive query.&nbsp;&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"885\" src=\"https:\/\/datadandies.nl\/wp-content\/uploads\/2023\/05\/20230306-Compound-interest-in-SQL-met-recursive-query-1024x885.jpg\" alt=\"\" class=\"wp-image-161\" srcset=\"https:\/\/datadandies.nl\/wp-content\/uploads\/2023\/05\/20230306-Compound-interest-in-SQL-met-recursive-query-1024x885.jpg 1024w, https:\/\/datadandies.nl\/wp-content\/uploads\/2023\/05\/20230306-Compound-interest-in-SQL-met-recursive-query-300x259.jpg 300w, https:\/\/datadandies.nl\/wp-content\/uploads\/2023\/05\/20230306-Compound-interest-in-SQL-met-recursive-query-768x664.jpg 768w, https:\/\/datadandies.nl\/wp-content\/uploads\/2023\/05\/20230306-Compound-interest-in-SQL-met-recursive-query.jpg 1030w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Wil je samengestelde rente, ofwel compound interest berekenen in T-SQL?&nbsp; Dit kan m.b.v. een recursive query. Een recursive query is een \u201cloop\u201d, oftewel, een query die zichzelf blijft herhalen. De syntax is relatief eenvoudig; in de onderstaande voorbeeld-query in T-SQL zeg je:\u00a0\u00a0 Je kunt in dergelijke berekeningen ook rekening houden met verschillende rentepercentages per jaar.&hellip;<\/p>\n<p class=\"more-link\"><a href=\"https:\/\/datadandies.nl\/index.php\/2023\/05\/18\/recursive-query-voor-compound-interest-in-sql\/\" class=\"themebutton\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[19,17,4],"class_list":["post-160","post","type-post","status-publish","format-standard","hentry","category-blog","tag-compoundinterest","tag-data","tag-sql"],"_links":{"self":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/160","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/comments?post=160"}],"version-history":[{"count":1,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/160\/revisions"}],"predecessor-version":[{"id":162,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/160\/revisions\/162"}],"wp:attachment":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/media?parent=160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/categories?post=160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/tags?post=160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}