{"id":16192,"date":"2020-05-26T15:56:21","date_gmt":"2020-05-26T15:56:21","guid":{"rendered":"https:\/\/ittutorial.org\/?p=16192"},"modified":"2020-06-15T13:01:56","modified_gmt":"2020-06-15T13:01:56","slug":"min-and-max-functions-in-oracle-sql-oracle-sql-tutorials-13","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/min-and-max-functions-in-oracle-sql-oracle-sql-tutorials-13\/","title":{"rendered":"MIN() and MAX() Functions in Oracle SQL | Oracle SQL Tutorials -13"},"content":{"rendered":"<p align=\"left\">Hi,<\/p>\n<p align=\"left\">I will explain MIN() and MAX() Functions 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=\"Vg4VmZnD0U\"><p><a href=\"https:\/\/ittutorial.org\/sql-select-statement-and-desc-command-in-oracle-sql-oracle-sql-tutorials-2\/\">SQL SELECT Statement and DESC Command in Oracle SQL | Oracle SQL Tutorials -2<\/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;SQL SELECT Statement and DESC Command in Oracle SQL | Oracle SQL Tutorials -2&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/sql-select-statement-and-desc-command-in-oracle-sql-oracle-sql-tutorials-2\/embed\/#?secret=WOQc16svUh#?secret=Vg4VmZnD0U\" data-secret=\"Vg4VmZnD0U\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>The MIN() function<\/strong><\/span><\/p>\n<p>You can find the smallest value of the selected column using the MIN() function.<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">MIN() Syntax<\/span><\/strong><\/p>\n<p>MIN() Function syntax is as follows.<\/p>\n<p>&nbsp;<\/p>\n<pre><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">SELECT<\/span>\u00a0MIN(<em>column_name<\/em>) <span class=\"sqlkeywordcolor\">FROM<\/span>\u00a0<em>table_name;<\/em>\r\n<\/span><\/pre>\n<div class=\"w3-example\">\n<pre class=\"w3-code notranslate sqlHigh\"><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">SELECT<\/span>\u00a0MIN(<em>column_name<\/em>) <span class=\"sqlkeywordcolor\">FROM <\/span><em>table_name<\/em>\r\n<span class=\"sqlkeywordcolor\">WHERE <\/span><em>condition<\/em>;<\/span><\/pre>\n<\/div>\n<div><\/div>\n<div><\/div>\n<div><\/div>\n<div>MIN Function examples are as follows.<\/div>\n<div>\n<pre>SQL&gt; select min(salary) from hr.employees;\r\n\r\nMIN(SALARY)\r\n-----------\r\n3100\r\n\r\nSQL&gt;<\/pre>\n<\/div>\n<pre>SQL&gt; select min(salary) from hr.employees where department_id&gt;100;\r\n\r\nMIN(SALARY)\r\n-----------\r\n9300\r\n\r\nSQL&gt;<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>The MAX() function<\/strong><\/span><\/p>\n<p>You can find the Largest value of the selected column using the MAX() function.<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">MAX() Syntax<\/span><\/strong><\/p>\n<p>MAX() Function syntax is as follows.<\/p>\n<p>&nbsp;<\/p>\n<pre><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">SELECT<\/span> MAX(<em>column_name<\/em>) <span class=\"sqlkeywordcolor\">FROM<\/span>\u00a0<em>table_name;<\/em>\r\n<\/span>\r\n\r\n<\/pre>\n<div class=\"w3-code notranslate sqlHigh\"><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">SELECT <\/span>MAX(<em>column_name<\/em>) <span class=\"sqlkeywordcolor\">FROM <\/span><em>table_name<\/em><br \/>\n<span class=\"sqlkeywordcolor\">WHERE <\/span><em>condition<\/em>;<\/span><\/div>\n<pre>\r\n<\/pre>\n<div><\/div>\n<div>MAX Function examples are as follows.<\/div>\n<div><\/div>\n<p>&nbsp;<\/p>\n<pre>SQL&gt; \r\nSQL&gt; select max(salary) from hr.employees;\r\n\r\nMAX(SALARY)\r\n-----------\r\n23000\r\n\r\nSQL&gt; \r\nSQL&gt; \r\nSQL&gt; select max(salary) from hr.employees where department_id&gt;100;\r\n\r\nMAX(SALARY)\r\n-----------\r\n13008\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 SQL Tutorial for Beginners, then read the following articles.<\/span><\/h4>\n<blockquote class=\"wp-embedded-content\" data-secret=\"0JJhz2IDs4\"><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=2li63oelaf#?secret=0JJhz2IDs4\" data-secret=\"0JJhz2IDs4\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<pre><\/pre>\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=\"rYCC4OsaFN\"><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=NQcG7ga5eS#?secret=rYCC4OsaFN\" data-secret=\"rYCC4OsaFN\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, I will explain MIN() and MAX() Functions 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":[11578,11575,11576,9037,11351,11304,3001,11302,3013,2673,11301,3715,4911,11566,11579,11580,11568,11570,11577,11582,11571,11574,11567,11573,11569,11572,11581,3000,3012,11790],"class_list":["post-16192","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle-sql","tag-having-max-sql","tag-having-min-sql","tag-how-to-use-min-function-in-sql-query","tag-oracle-dba-tutorial","tag-oracle-live-sql","tag-oracle-sql-developer-tutorial","tag-oracle-sql-tutorial","tag-oracle-sql-tutorial-pdf","tag-oracle-sql-tutorials","tag-oracle-tutorial","tag-oracle-tutorial-pdf","tag-pl-sql-tutorial","tag-sql-functions","tag-sql-max-and-min-in-one-select","tag-sql-max-date","tag-sql-max-function-on-string","tag-sql-max-group-by","tag-sql-max-of-two-values","tag-sql-maxcount","tag-sql-min-and-max-in-same-query","tag-sql-min-date","tag-sql-min-function-on-string","tag-sql-min-group-by","tag-sql-min-of-two-columns","tag-sql-min-of-two-values","tag-sql-select-min-value-from-multiple-rows","tag-sql-server-select-row-with-max-value","tag-sql-tutorial","tag-sql-tutorials","tag-sql-tutorials-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\/16192","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=16192"}],"version-history":[{"count":3,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16192\/revisions"}],"predecessor-version":[{"id":16605,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16192\/revisions\/16605"}],"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=16192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=16192"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=16192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}