{"id":8352,"date":"2024-03-14T07:59:20","date_gmt":"2024-03-14T07:59:20","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-group-by-clause-in-oracle-database\/"},"modified":"2025-08-03T03:43:01","modified_gmt":"2025-08-03T03:43:01","slug":"how-to-use-the-group-by-clause-in-oracle-database","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-group-by-clause-in-oracle-database\/","title":{"rendered":"Oracle SQL GROUP BY Clause Tutorial"},"content":{"rendered":"<p>In Oracle database, the GROUP BY clause is used to group the query results based on specified columns. The specific usage is as follows:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> column1, column2, aggregate_function(column3)\r\n<span class=\"hljs-keyword\">FROM<\/span> table_name\r\n<span class=\"hljs-keyword\">GROUP<\/span> <span class=\"hljs-keyword\">BY<\/span> column1, column2;\r\n<\/code><\/pre>\n<p>In the given statement, column1 and column2 are the columns that need to be grouped, while aggregate_function is the function used to aggregate the results after grouping, such as SUM, AVG, COUNT, etc. It is important to note that, besides aggregate functions, the columns in the SELECT statement must either be in the GROUP BY clause or be parameters of the aggregate function.<\/p>\n<p>For example, if we have a table called &#8216;students&#8217; that includes students&#8217; names, ages, and grades, we can use the following statement to group students by age and calculate the average grade for each age group:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> age, <span class=\"hljs-built_in\">AVG<\/span>(grade)\r\n<span class=\"hljs-keyword\">FROM<\/span> students\r\n<span class=\"hljs-keyword\">GROUP<\/span> <span class=\"hljs-keyword\">BY<\/span> age;\r\n<\/code><\/pre>\n<p>This will result in the average score for each age group. It is important to note that if you want to group all columns, you can simply use the GROUP BY clause without specifying any columns, which will merge all rows into one group.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Oracle database, the GROUP BY clause is used to group the query results based on specified columns. The specific usage is as follows: SELECT column1, column2, aggregate_function(column3) FROM table_name GROUP BY column1, column2; In the given statement, column1 and column2 are the columns that need to be grouped, while aggregate_function is the function used [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[408,284,871,472,292],"class_list":["post-8352","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-aggregate-functions","tag-database","tag-group-by","tag-oracle-sql","tag-query"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle SQL GROUP BY Clause Tutorial - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Oracle GROUP BY clause tutorial with examples. Learn to group data and use aggregate functions like SUM, COUNT, and AVG.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-group-by-clause-in-oracle-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle SQL GROUP BY Clause Tutorial\" \/>\n<meta property=\"og:description\" content=\"Oracle GROUP BY clause tutorial with examples. Learn to group data and use aggregate functions like SUM, COUNT, and AVG.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-group-by-clause-in-oracle-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T07:59:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-03T03:43:01+00:00\" \/>\n<meta name=\"author\" content=\"Jackson Davis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jackson Davis\" \/>\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:\/\/www.silicloud.com\/blog\/how-to-use-the-group-by-clause-in-oracle-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-group-by-clause-in-oracle-database\/\"},\"author\":{\"name\":\"Jackson Davis\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\"},\"headline\":\"Oracle SQL GROUP BY Clause Tutorial\",\"datePublished\":\"2024-03-14T07:59:20+00:00\",\"dateModified\":\"2025-08-03T03:43:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-group-by-clause-in-oracle-database\/\"},\"wordCount\":174,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"aggregate functions\",\"database\",\"GROUP BY\",\"Oracle SQL\",\"Query\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-group-by-clause-in-oracle-database\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-group-by-clause-in-oracle-database\/\",\"name\":\"Oracle SQL GROUP BY Clause Tutorial - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T07:59:20+00:00\",\"dateModified\":\"2025-08-03T03:43:01+00:00\",\"description\":\"Oracle GROUP BY clause tutorial with examples. Learn to group data and use aggregate functions like SUM, COUNT, and AVG.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-group-by-clause-in-oracle-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-group-by-clause-in-oracle-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-group-by-clause-in-oracle-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle SQL GROUP BY Clause Tutorial\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\",\"name\":\"Jackson Davis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"caption\":\"Jackson Davis\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle SQL GROUP BY Clause Tutorial - Blog - Silicon Cloud","description":"Oracle GROUP BY clause tutorial with examples. Learn to group data and use aggregate functions like SUM, COUNT, and AVG.","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:\/\/www.silicloud.com\/blog\/how-to-use-the-group-by-clause-in-oracle-database\/","og_locale":"en_US","og_type":"article","og_title":"Oracle SQL GROUP BY Clause Tutorial","og_description":"Oracle GROUP BY clause tutorial with examples. Learn to group data and use aggregate functions like SUM, COUNT, and AVG.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-group-by-clause-in-oracle-database\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T07:59:20+00:00","article_modified_time":"2025-08-03T03:43:01+00:00","author":"Jackson Davis","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Jackson Davis","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-group-by-clause-in-oracle-database\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-group-by-clause-in-oracle-database\/"},"author":{"name":"Jackson Davis","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350"},"headline":"Oracle SQL GROUP BY Clause Tutorial","datePublished":"2024-03-14T07:59:20+00:00","dateModified":"2025-08-03T03:43:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-group-by-clause-in-oracle-database\/"},"wordCount":174,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["aggregate functions","database","GROUP BY","Oracle SQL","Query"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-group-by-clause-in-oracle-database\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-group-by-clause-in-oracle-database\/","name":"Oracle SQL GROUP BY Clause Tutorial - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T07:59:20+00:00","dateModified":"2025-08-03T03:43:01+00:00","description":"Oracle GROUP BY clause tutorial with examples. Learn to group data and use aggregate functions like SUM, COUNT, and AVG.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-group-by-clause-in-oracle-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-use-the-group-by-clause-in-oracle-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-group-by-clause-in-oracle-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle SQL GROUP BY Clause Tutorial"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350","name":"Jackson Davis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","caption":"Jackson Davis"},"url":"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/8352","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=8352"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/8352\/revisions"}],"predecessor-version":[{"id":153156,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/8352\/revisions\/153156"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=8352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=8352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=8352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}