{"id":16786,"date":"2022-10-22T04:18:25","date_gmt":"2022-10-21T22:48:25","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/"},"modified":"2022-10-22T04:18:25","modified_gmt":"2022-10-21T22:48:25","slug":"solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/","title":{"rendered":"[Solved] SQL query to classify triangles into Equilateral, Isosceles, etc"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-42446524\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"42446524\" data-parentid=\"42446197\" data-score=\"2\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>Keep in mind that CASE statements are evaluated IN ORDER &#8211; the first WHEN clause that fits &#8220;wins&#8221; and no further evaluation is made. So:<\/p>\n<pre><code>with\n     triangles ( A, B, C ) as (\n       select 20, 20, 23 from dual union all\n       select 20, 20, 20 from dual union all\n       select 20, 21, 22 from dual union all\n       select 13, 14, 30 from dual\n     )\nselect A, B, C, \n       case\n            when A+B &lt;= C  or B+C &lt;= A or C+A &lt;= B then 'Not A Triangle'                \n            when A    = B and B    = C             then 'Equilateral'\n            when A    = B  or B    = C or A    = C then 'Isosceles'\n            else                                        'Scalene'  \n            end  as classification\nfrom   triangles\n;\n\n  A   B   C   CLASSIFICATION\n--- --- ---   --------------\n 20  20  23   Isosceles\n 20  20  20   Equilateral\n 20  21  22   Scalene\n 13  14  30   Not A Triangle\n\n4 rows selected.\n<\/code><\/pre>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">11<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved SQL query to classify triangles into Equilateral, Isosceles, etc <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] Keep in mind that CASE statements are evaluated IN ORDER &#8211; the first WHEN clause that fits &#8220;wins&#8221; and no further evaluation is made. So: with triangles ( A, B, C ) as ( select 20, 20, 23 from dual union all select 20, 20, 20 from dual union all select 20, 21, 22 &#8230; <a title=\"[Solved] SQL query to classify triangles into Equilateral, Isosceles, etc\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/\" aria-label=\"More on [Solved] SQL query to classify triangles into Equilateral, Isosceles, etc\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[838,341],"class_list":["post-16786","post","type-post","status-publish","format-standard","hentry","category-solved","tag-oracle","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] SQL query to classify triangles into Equilateral, Isosceles, etc - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] SQL query to classify triangles into Equilateral, Isosceles, etc - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] Keep in mind that CASE statements are evaluated IN ORDER &#8211; the first WHEN clause that fits &#8220;wins&#8221; and no further evaluation is made. So: with triangles ( A, B, C ) as ( select 20, 20, 23 from dual union all select 20, 20, 20 from dual union all select 20, 21, 22 ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-21T22:48:25+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] SQL query to classify triangles into Equilateral, Isosceles, etc\",\"datePublished\":\"2022-10-21T22:48:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/\"},\"wordCount\":47,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"oracle\",\"sql\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/\",\"name\":\"[Solved] SQL query to classify triangles into Equilateral, Isosceles, etc - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-10-21T22:48:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] SQL query to classify triangles into Equilateral, Isosceles, etc\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] SQL query to classify triangles into Equilateral, Isosceles, etc - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] SQL query to classify triangles into Equilateral, Isosceles, etc - JassWeb","og_description":"[ad_1] Keep in mind that CASE statements are evaluated IN ORDER &#8211; the first WHEN clause that fits &#8220;wins&#8221; and no further evaluation is made. So: with triangles ( A, B, C ) as ( select 20, 20, 23 from dual union all select 20, 20, 20 from dual union all select 20, 21, 22 ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/","og_site_name":"JassWeb","article_published_time":"2022-10-21T22:48:25+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] SQL query to classify triangles into Equilateral, Isosceles, etc","datePublished":"2022-10-21T22:48:25+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/"},"wordCount":47,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["oracle","sql"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/","url":"https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/","name":"[Solved] SQL query to classify triangles into Equilateral, Isosceles, etc - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-10-21T22:48:25+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-sql-query-to-classify-triangles-into-equilateral-isosceles-etc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] SQL query to classify triangles into Equilateral, Isosceles, etc"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/16786","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=16786"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/16786\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=16786"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=16786"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=16786"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}