{"id":181,"date":"2020-05-27T20:11:34","date_gmt":"2020-05-27T19:11:34","guid":{"rendered":"http:\/\/www.pastscho.de\/?p=181"},"modified":"2020-05-28T08:15:27","modified_gmt":"2020-05-28T07:15:27","slug":"with-clause-in-hana","status":"publish","type":"post","link":"https:\/\/www.pastscho.de\/?p=181","title":{"rendered":"With-Clause in HANA"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Komplexe SQL-Abfragen lassen mit der WITH-CLAUSE gut zerlegen, bleiben leichter zu lesen und k\u00f6nnen am Ende wieder zusammengebaut werden. Hier ein Beispiel:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>with v1_erste_view as ( \n--------------------------------------------------------------------------------------------------------------------------------\n-- View 1\n--\n     select 'Das ist die erste View.' txt from dummy)\n--------------------------------------------------------------------------------------------------------------------------------\n-- View 2\n--     \n , v2_zweite_view as  (\n \t  select 'Das ist die zweite View.' txt from dummy)\n--------------------------------------------------------------------------------------------------------------------------------\n-- View 3\n--     \n ,  v3_dritte_view as ( \n \t   select 'Das ist die dritte View.' txt from dummy)\n--------------------------------------------------------------------------------------------------------------------------------\n-- Select Statment\n--     \nselect txt\n  from v1_erste_view\nunion all\nselect txt\n  from v2_zweite_view\nunion all \nselect txt\n  from v3_dritte_view\norder by 1;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Komplexe SQL-Abfragen lassen mit der WITH-CLAUSE gut zerlegen, bleiben leichter zu lesen und k\u00f6nnen am Ende wieder zusammengebaut werden. Hier ein Beispiel:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-181","post","type-post","status-publish","format-standard","hentry","category-powercenter"],"_links":{"self":[{"href":"https:\/\/www.pastscho.de\/index.php?rest_route=\/wp\/v2\/posts\/181","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pastscho.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pastscho.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pastscho.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pastscho.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=181"}],"version-history":[{"count":2,"href":"https:\/\/www.pastscho.de\/index.php?rest_route=\/wp\/v2\/posts\/181\/revisions"}],"predecessor-version":[{"id":183,"href":"https:\/\/www.pastscho.de\/index.php?rest_route=\/wp\/v2\/posts\/181\/revisions\/183"}],"wp:attachment":[{"href":"https:\/\/www.pastscho.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=181"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pastscho.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=181"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pastscho.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}