{"id":16602,"date":"2020-06-18T15:37:31","date_gmt":"2020-06-18T15:37:31","guid":{"rendered":"https:\/\/ittutorial.org\/?p=16602"},"modified":"2020-06-18T15:37:31","modified_gmt":"2020-06-18T15:37:31","slug":"group-by-statement-in-oracle-sql-oracle-sql-tutorials-16","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/group-by-statement-in-oracle-sql-oracle-sql-tutorials-16\/","title":{"rendered":"GROUP BY Statement in Oracle SQL | Oracle SQL Tutorials -16"},"content":{"rendered":"<p align=\"left\">Hi,<\/p>\n<p align=\"left\">I will explain GROUP BY Statement in Oracle SQL in this post of Oracle SQL Tutorial series.<\/p>\n<p align=\"left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16079\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial.png\" alt=\"\" width=\"387\" height=\"311\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial.png 387w, https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial-300x241.png 300w\" sizes=\"auto, (max-width: 387px) 100vw, 387px\" \/><\/p>\n<p align=\"left\"><!--more--><\/p>\n<p align=\"left\">\n<p align=\"left\"><span style=\"color: #ff0000;\"><strong>Read the previous post of this tutorial series before this.<\/strong><\/span><\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"vqXVbCzJAY\"><p><a href=\"https:\/\/ittutorial.org\/in-and-between-operator-in-oracle-sql-oracle-sql-tutorials-15\/\">IN and BETWEEN Operator in Oracle SQL | Oracle SQL Tutorials -15<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;IN and BETWEEN Operator in Oracle SQL | Oracle SQL Tutorials -15&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/in-and-between-operator-in-oracle-sql-oracle-sql-tutorials-15\/embed\/#?secret=w4OzYpBo3I#?secret=vqXVbCzJAY\" data-secret=\"vqXVbCzJAY\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #ff0000;\">GROUP BY Statement<\/span><\/h4>\n<p>GROUP BY statement is very popular in Oracle SQL. You can group specific or all rows which have same values into summary rows.<\/p>\n<p>Aggregate functions (MAX, MIN, SUM, AVG,COUNT) are often used in the Group by statements.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h5><span style=\"color: #ff0000;\">GROUP BY Syntax<\/span><\/h5>\n<p>GROUP BY syntax is as follows.<\/p>\n<pre><span class=\"sqlkeywordcolor\">SELECT<\/span> <em>column1,column2<\/em> <span class=\"sqlkeywordcolor\">FROM<\/span>\u00a0<em>table_name <\/em><span class=\"sqlkeywordcolor\">WHERE<\/span>\u00a0<em>condition <\/em><span class=\"sqlkeywordcolor\">GROUP<\/span>\u00a0<span class=\"sqlkeywordcolor\">BY<\/span>\u00a0<em>column1,column2;\r\n<\/em>\r\n<\/pre>\n<pre><span class=\"sqlkeywordcolor\">SELECT<\/span> <em>column1,column2<\/em> <span class=\"sqlkeywordcolor\">FROM<\/span>\u00a0<em>table_name <\/em><span class=\"sqlkeywordcolor\">WHERE<\/span>\u00a0<em>condition <\/em><span class=\"sqlkeywordcolor\">GROUP<\/span>\u00a0<span class=\"sqlkeywordcolor\">BY<\/span>\u00a0<em>column1,column2<\/em><\/pre>\n<pre><span class=\"sqlkeywordcolor\">ORDER<\/span>\u00a0<span class=\"sqlkeywordcolor\">BY<\/span>\u00a0<em>column_name(s);<\/em><\/pre>\n<pre>\r\n<span class=\"sqlkeywordcolor\">SELECT<\/span>\u00a0<em>column_name(s) <\/em><span class=\"sqlkeywordcolor\">FROM<\/span>\u00a0<em>table_name <\/em><span class=\"sqlkeywordcolor\">WHERE<\/span>\u00a0<em>condition <\/em><span class=\"sqlkeywordcolor\">GROUP<\/span>\u00a0<span class=\"sqlkeywordcolor\">BY<\/span>\u00a0<em>column_name(s)\r\n<\/em><span class=\"sqlkeywordcolor\">ORDER<\/span>\u00a0<span class=\"sqlkeywordcolor\">BY<\/span>\u00a0<em>column_name(s);<\/em><\/pre>\n<div><\/div>\n<div><\/div>\n<div><\/div>\n<div><\/div>\n<div><span style=\"color: #ff0000;\"><strong>Group by<\/strong> <\/span>examples are as follows.<\/div>\n<div>\n<pre>\r\nSQL&gt; select first_name,last_name,salary from hr.employees where department_id in (20,30,40) group by first_name,last_name,salary;  \r\n\r\nFIRST_NAME           LAST_NAME                     SALARY\r\n-------------------- ------------------------- ----------\r\nAlexander            Khoo                            4100\r\nPat                  Fay                             7000\r\nKaren                Colmenares                      3500\r\nMichael              Hartstein                      14000\r\nGuy                  Himuro                          3600\r\nDen                  Raphaely                       12000\r\nShelli               Baida                           3900\r\nSigal                Tobias                          3800\r\nSusan                Mavris                          7500\r\n\r\n9 rows selected.\r\n\r\n\r\nSQL&gt; select salary,count(*) from hr.employees where department_id in (20,30,40,50,60,70) group by salary; \r\n\r\n    SALARY   COUNT(*)\r\n---------- ----------\r\n      5200          2\r\n     12000          1\r\n      9000          1\r\n      4000          2\r\n      5000          1\r\n     14000          1\r\n     11000          1\r\n     10000          1\r\n      3900          3\r\n      3400          2\r\n      4600          2\r\n\r\n    SALARY   COUNT(*)\r\n---------- ----------\r\n      4500          1\r\n      3800          4\r\n      3500          6\r\n      4100          4\r\n      4400          1\r\n      4800          1\r\n      8900          1\r\n      7500          2\r\n      4200          4\r\n      4300          2\r\n      4900          1\r\n\r\n    SALARY   COUNT(*)\r\n---------- ----------\r\n      3600          4\r\n      3700          2\r\n      5800          2\r\n      6800          1\r\n      3200          2\r\n      3100          1\r\n      5100          1\r\n      7000          2\r\n      9200          1\r\n\r\n31 rows selected.\r\n\r\nSQL&gt;<\/pre>\n<\/div>\n<pre>\r\n\r\n\r\n<\/pre>\n<pre>SQL&gt; select department_id,sum(salary) from hr.employees group by department_id;\r\n\r\nDEPARTMENT_ID SUM(SALARY)\r\n------------- -----------\r\n          100       57608\r\n           30       30900\r\n                     8000\r\n           90       46000\r\n           20       21000\r\n           70       11000\r\n          110       22308\r\n           50      201400\r\n           80      338500\r\n           40        7500\r\n           60       33800\r\n\r\nDEPARTMENT_ID SUM(SALARY)\r\n------------- -----------\r\n           10        5400\r\n\r\n12 rows selected.\r\n\r\nSQL&gt;<\/pre>\n<p>&nbsp;<\/p>\n<h4><\/h4>\n<h4><span style=\"color: #ff0000;\">Do you want to learn Oracle SQL Tutorial for Beginners, then read the following articles.<\/span><\/h4>\n<blockquote class=\"wp-embedded-content\" data-secret=\"Q64onsCmvN\"><p><a href=\"https:\/\/ittutorial.org\/oracle-sql-tutorials-for-beginners-learn-sql-tutorials-sql-course\/\">Oracle SQL Tutorials For Beginners &#8211; Learn Oracle SQL from scratch with Oracle SQL Online Course<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Oracle SQL Tutorials For Beginners &#8211; Learn Oracle SQL from scratch with Oracle SQL Online Course&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/oracle-sql-tutorials-for-beginners-learn-sql-tutorials-sql-course\/embed\/#?secret=WLtd0qyV85#?secret=Q64onsCmvN\" data-secret=\"Q64onsCmvN\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, I will explain GROUP BY Statement in Oracle SQL in this post of Oracle SQL Tutorial series.<\/p>\n","protected":false},"author":1,"featured_media":16079,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3019],"tags":[11812,11807,11808,11806,11817,11384,11802,11811,11815,9037,11803,11805,11810,11809,11351,11304,11804,3001,11302,2673,11301,3715,11814,11813,11816],"class_list":["post-16602","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle-sql","tag-group-by-having-sql","tag-group-by-in-oracle-with-count","tag-group-by-in-oracle-with-join","tag-group-by-in-sql","tag-group-by-oracle","tag-group-by-sql","tag-group-by-statement-in-oracle-sql","tag-multiple-group-by-sql","tag-not-a-group-by-expression","tag-oracle-dba-tutorial","tag-oracle-group-by-having","tag-oracle-group-by-multiple-columns","tag-oracle-group-by-order-by","tag-oracle-group-by-rollup","tag-oracle-live-sql","tag-oracle-sql-developer-tutorial","tag-oracle-sql-not-a-group-by-expression","tag-oracle-sql-tutorial","tag-oracle-sql-tutorial-pdf","tag-oracle-tutorial","tag-oracle-tutorial-pdf","tag-pl-sql-tutorial","tag-sql-count-group-by-multiple-columns","tag-sql-group-by-count","tag-sql-group-by-sum"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16602","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=16602"}],"version-history":[{"count":2,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16602\/revisions"}],"predecessor-version":[{"id":16626,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16602\/revisions\/16626"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/16079"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=16602"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=16602"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=16602"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}