{"id":16105,"date":"2020-05-21T22:52:18","date_gmt":"2020-05-21T22:52:18","guid":{"rendered":"https:\/\/ittutorial.org\/?p=16105"},"modified":"2020-05-23T01:28:31","modified_gmt":"2020-05-23T01:28:31","slug":"order-by-in-oracle-sql-oracle-sql-tutorials-6","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/order-by-in-oracle-sql-oracle-sql-tutorials-6\/","title":{"rendered":"ORDER BY in Oracle SQL | Oracle SQL Tutorials -6"},"content":{"rendered":"<p align=\"left\">Hi,<\/p>\n<p align=\"left\">I will explain ORDER BY in Oracle SQL\u00a0 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=\"CCkqnt65vc\"><p><a href=\"https:\/\/ittutorial.org\/and-or-and-not-operators-in-oracle-sql-oracle-sql-tutorials-5\/\">AND, OR and NOT Operators in Oracle SQL | Oracle SQL Tutorials -5<\/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;AND, OR and NOT Operators in Oracle SQL | Oracle SQL Tutorials -5&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/and-or-and-not-operators-in-oracle-sql-oracle-sql-tutorials-5\/embed\/#?secret=Welg68X4jq#?secret=CCkqnt65vc\" data-secret=\"CCkqnt65vc\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p>The ORDER BY is most popular keyword in Oracle SQL that is used to sort the result as ascending and descending order.<\/p>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #ff0000;\">ORDER BY Syntax<\/span><\/h4>\n<div class=\"w3-example\">\n<pre class=\"w3-code notranslate sqlHigh\"><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">SELECT<\/span>\u00a0<em>column1<\/em>,<em> column2, ...<\/em><span class=\"sqlkeywordcolor\">FROM<\/span>\u00a0<em>table_name<\/em>\r\n<span class=\"sqlkeywordcolor\">ORDER<\/span>\u00a0<span class=\"sqlkeywordcolor\">BY<\/span>\u00a0<em>column1, column2, ...\u00a0<\/em><strong><span style=\"color: #ff0000;\"><span class=\"sqlkeywordcolor\">ASC<\/span>|<span class=\"sqlkeywordcolor\">DESC<\/span><\/span><\/strong>;<\/span><\/pre>\n<\/div>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>Order by<\/strong><\/span> keyword sorts the results in ascending order by default, so If you sort your Results in ascending order, no need to use ASC ( Ascending )<\/p>\n<p>&nbsp;<\/p>\n<p>You can use Order by keyword as follows.<\/p>\n<p>&nbsp;<\/p>\n<pre>SQL&gt; SELECT DEPARTMENT_ID, FIRST_NAME, LAST_NAME, SALARY FROM HR.EMPLOYEES WHERE DEPARTMENT_ID&lt;50  ORDER BY SALARY;\r\n\r\nDEPARTMENT_ID FIRST_NAME           LAST_NAME                     SALARY\r\n------------- -------------------- ------------------------- ----------\r\n           30 Karen                Colmenares                      2500\r\n           30 Guy                  Himuro                          2600\r\n           30 Sigal                Tobias                          2800\r\n           30 Shelli               Baida                           2900\r\n           30 Alexander            Khoo                            3100\r\n           10 Jennifer             Whalen                          4400\r\n           20 Pat                  Fay                             6000\r\n           40 Susan                Mavris                          6500\r\n           30 Den                  Raphaely                       11000\r\n           20 Michael              Hartstein                      13000\r\n\r\n10 rows selected.\r\n\r\nSQL&gt;<\/pre>\n<p>&nbsp;<\/p>\n<p>Using ASC or not is not important, both of them are the same result as follows.<\/p>\n<pre>SQL&gt; SELECT DEPARTMENT_ID, FIRST_NAME, LAST_NAME, SALARY FROM HR.EMPLOYEES WHERE DEPARTMENT_ID&lt;50  ORDER BY SALARY ASC;\r\n\r\nDEPARTMENT_ID FIRST_NAME           LAST_NAME                     SALARY\r\n------------- -------------------- ------------------------- ----------\r\n           30 Karen                Colmenares                      2500\r\n           30 Guy                  Himuro                          2600\r\n           30 Sigal                Tobias                          2800\r\n           30 Shelli               Baida                           2900\r\n           30 Alexander            Khoo                            3100\r\n           10 Jennifer             Whalen                          4400\r\n           20 Pat                  Fay                             6000\r\n           40 Susan                Mavris                          6500\r\n           30 Den                  Raphaely                       11000\r\n           20 Michael              Hartstein                      13000\r\n\r\n10 rows selected.\r\n\r\nSQL&gt;<\/pre>\n<p>&nbsp;<\/p>\n<p>You can sort your result in Descending ( DESC\u00a0 ) as follows.<\/p>\n<pre><\/pre>\n<pre>SQL&gt; SELECT DEPARTMENT_ID, FIRST_NAME, LAST_NAME, SALARY FROM HR.EMPLOYEES WHERE DEPARTMENT_ID&lt;50  ORDER BY SALARY DESC;     \r\n\r\nDEPARTMENT_ID FIRST_NAME           LAST_NAME                     SALARY\r\n------------- -------------------- ------------------------- ----------\r\n           20 Michael              Hartstein                      13000\r\n           30 Den                  Raphaely                       11000\r\n           40 Susan                Mavris                          6500\r\n           20 Pat                  Fay                             6000\r\n           10 Jennifer             Whalen                          4400\r\n           30 Alexander            Khoo                            3100\r\n           30 Shelli               Baida                           2900\r\n           30 Sigal                Tobias                          2800\r\n           30 Guy                  Himuro                          2600\r\n           30 Karen                Colmenares                      2500\r\n\r\n10 rows selected.\r\n\r\nSQL&gt;<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #ff0000;\">ORDER BY Several Columns<\/span><\/h4>\n<p>You can sort your result set order by several columns as follows.<\/p>\n<pre>SQL&gt; \r\nSQL&gt; SELECT DEPARTMENT_ID, FIRST_NAME, LAST_NAME, SALARY FROM HR.EMPLOYEES WHERE DEPARTMENT_ID&lt;50  ORDER BY SALARY DESC, DEPARTMENT_ID ASC;\r\n\r\nDEPARTMENT_ID FIRST_NAME           LAST_NAME                     SALARY\r\n------------- -------------------- ------------------------- ----------\r\n           20 Michael              Hartstein                      13000\r\n           30 Den                  Raphaely                       11000\r\n           40 Susan                Mavris                          6500\r\n           20 Pat                  Fay                             6000\r\n           10 Jennifer             Whalen                          4400\r\n           30 Alexander            Khoo                            3100\r\n           30 Shelli               Baida                           2900\r\n           30 Sigal                Tobias                          2800\r\n           30 Guy                  Himuro                          2600\r\n           30 Karen                Colmenares                      2500\r\n\r\n10 rows selected.\r\n\r\nSQL&gt; \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<\/pre>\n<p>The second example is as follows.<\/p>\n<pre>SQL&gt; SELECT DEPARTMENT_ID, FIRST_NAME, LAST_NAME, SALARY FROM HR.EMPLOYEES WHERE DEPARTMENT_ID&lt;50  ORDER BY DEPARTMENT_ID DESC, SALARY DESC;\r\n\r\nDEPARTMENT_ID FIRST_NAME           LAST_NAME                     SALARY\r\n------------- -------------------- ------------------------- ----------\r\n           40 Susan                Mavris                          6500\r\n           30 Den                  Raphaely                       11000\r\n           30 Alexander            Khoo                            3100\r\n           30 Shelli               Baida                           2900\r\n           30 Sigal                Tobias                          2800\r\n           30 Guy                  Himuro                          2600\r\n           30 Karen                Colmenares                      2500\r\n           20 Michael              Hartstein                      13000\r\n           20 Pat                  Fay                             6000\r\n           10 Jennifer             Whalen                          4400\r\n\r\n10 rows selected.\r\n\r\nSQL&gt;<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>The third example is as follows.<\/p>\n<p>&nbsp;<\/p>\n<pre>SQL&gt; SELECT DEPARTMENT_ID, FIRST_NAME, LAST_NAME, SALARY FROM HR.EMPLOYEES WHERE DEPARTMENT_ID&lt;50  ORDER BY SALARY ASC, FIRST_NAME DESC;\r\n\r\nDEPARTMENT_ID FIRST_NAME           LAST_NAME                     SALARY\r\n------------- -------------------- ------------------------- ----------\r\n           30 Karen                Colmenares                      2500\r\n           30 Guy                  Himuro                          2600\r\n           30 Sigal                Tobias                          2800\r\n           30 Shelli               Baida                           2900\r\n           30 Alexander            Khoo                            3100\r\n           10 Jennifer             Whalen                          4400\r\n           20 Pat                  Fay                             6000\r\n           40 Susan                Mavris                          6500\r\n           30 Den                  Raphaely                       11000\r\n           20 Michael              Hartstein                      13000\r\n\r\n10 rows selected.\r\n\r\nSQL&gt;<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #ff0000;\">Do you want to learn Oracle Database for Beginners, then read the following articles.<\/span><\/h4>\n<blockquote class=\"wp-embedded-content\" data-secret=\"Dmc2sEO7p5\"><p><a href=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/\">Oracle Tutorial | Oracle Database Tutorials for Beginners  ( Junior Oracle DBA )<\/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 Tutorial | Oracle Database Tutorials for Beginners  ( Junior Oracle DBA )&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/embed\/#?secret=IQLdn9jiLq#?secret=Dmc2sEO7p5\" data-secret=\"Dmc2sEO7p5\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, I will explain ORDER BY in Oracle SQL\u00a0 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":[11351,11424,11425,11302,11301,11421,11418,3715,11414,11417,11416,11415,11422,11423,11420,11419,2605],"class_list":["post-16105","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle-sql","tag-oracle-live-sql","tag-oracle-live-sql-tutorial","tag-oracle-sql-tutorial-oracle-sql-developer","tag-oracle-sql-tutorial-pdf","tag-oracle-tutorial-pdf","tag-order-by-column-number-in-sql","tag-order-by-oracle","tag-pl-sql-tutorial","tag-sql-order-by-date","tag-sql-order-by-group-by","tag-sql-order-by-multiple-columns","tag-sql-order-by-number","tag-sql-order-by-specific-sequence","tag-sql-order-by-specific-values","tag-sql-order-by-two-columns-at-the-same-time","tag-sql-order-by-count","tag-what-is-oracle"],"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\/16105","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=16105"}],"version-history":[{"count":4,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16105\/revisions"}],"predecessor-version":[{"id":16110,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16105\/revisions\/16110"}],"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=16105"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=16105"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=16105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}