MySql DB

MySQL MIN and MAX

Last modified on: December 11, 2024

<div class="flex-shrink-0 flex flex-col relative items-end">
<div>
<div class="pt-0">
<div class="gizmo-bot-avatar flex h-8 w-8 items-center justify-center overflow-hidden rounded-full">&nbsp;</div>
</div>
</div>
</div>
<div class="group/conversation-turn relative flex w-full min-w-0 flex-col agent-turn">
<div class="flex-col gap-1 md:gap-3">
<div class="flex max-w-full flex-col flex-grow">
<div class="min-h-8 text-message flex w-full flex-col items-end gap-2 whitespace-normal break-words text-start [.text-message+&amp;]:mt-5" dir="auto" data-message-author-role="assistant" data-message-id="0afc23e6-37cb-40e0-9035-fed64afb5326" data-message-model-slug="gpt-4o">
<div class="flex w-full flex-col gap-1 empty:hidden first:pt-[3px]">
<div class="markdown prose w-full break-words dark:prose-invert light">
<h3>MySQL MIN() and MAX() Functions: Finding the Smallest and Largest Values</h3>
<p>The <strong><code>MIN()</code></strong> and <strong><code>MAX()</code></strong> functions in MySQL are aggregate functions used to find the smallest and largest values in a column, respectively. They are commonly used in <code>SELECT</code> queries to analyze data.</p>
<hr />
<h3>Syntax</h3>
<h4><strong>MIN()</strong></h4>
<div class="contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950">
<div class="flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none">sql</div>
<div class="sticky top-9 md:top-[5.75rem]">
<div class="absolute bottom-0 right-2 flex h-9 items-center">
<div class="flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary">
<pre class="language-php"><code>SELECT MIN(column_name)
FROM table_name
WHERE condition;
</code></pre>
</div>
</div>
</div>
</div>
<h4><strong>MAX()</strong></h4>
<div class="contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950">
<div class="flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none">sql</div>
<div class="sticky top-9 md:top-[5.75rem]">
<div class="absolute bottom-0 right-2 flex h-9 items-center">
<div class="flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary">
<pre class="language-php"><code>SELECT MAX(column_name)
FROM table_name
WHERE condition;
</code></pre>
</div>
</div>
</div>
</div>
<ul>
<li><strong><code>column_name</code></strong>: The column you want to find the minimum or maximum value from.</li>
<li><strong><code>table_name</code></strong>: The table where the column is located.</li>
<li><strong><code>condition</code></strong>: Optional filters to narrow down the results.</li>
</ul>
<hr />
<h3>Examples</h3>
<h4>1. <strong>Basic Usage</strong></h4>
<p>Find the smallest and largest salary from an <code>employees</code> table:</p>
<div class="contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950">
<div class="flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none">sql</div>
<div class="sticky top-9 md:top-[5.75rem]">
<div class="absolute bottom-0 right-2 flex h-9 items-center">
<div class="flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary">
<pre class="language-php"><code>SELECT MIN(salary) AS lowest_salary, MAX(salary) AS highest_salary
FROM employees;
</code></pre>
</div>
</div>
</div>
</div>
<h4>2. <strong>MIN and MAX with Conditions</strong></h4>
<p>Find the highest salary for employees in the "Sales" department:</p>
<div class="contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950">
<div class="flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none">sql</div>
<div class="sticky top-9 md:top-[5.75rem]">
<div class="absolute bottom-0 right-2 flex h-9 items-center">
<div class="flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary">
<pre class="language-php"><code>SELECT MAX(salary) AS highest_salary
FROM employees
WHERE department = 'Sales';
</code></pre>
</div>
</div>
</div>
</div>
<p>Find the minimum age of employees hired after 2020:</p>
<div class="contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950">
<div class="flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none">sql</div>
<div class="sticky top-9 md:top-[5.75rem]">
<div class="absolute bottom-0 right-2 flex h-9 items-center">
<div class="flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary">
<pre class="language-php"><code>SELECT MIN(age) AS youngest_employee
FROM employees
WHERE hire_date &gt; '2020-01-01';
</code></pre>
</div>
</div>
</div>
</div>
<h4>3. <strong>Using MIN and MAX on Text Columns</strong></h4>
<p>Find the alphabetically first and last names in a table:</p>
<div class="contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950">
<div class="flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none">sql</div>
<div class="sticky top-9 md:top-[5.75rem]">
<div class="absolute bottom-0 right-2 flex h-9 items-center">
<div class="flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary">
<pre class="language-php"><code>SELECT MIN(name) AS first_name, MAX(name) AS last_name
FROM users;
</code></pre>
</div>
</div>
</div>
</div>
<h4>4. <strong>Combining MIN and MAX with GROUP BY</strong></h4>
<p>Find the minimum and maximum salaries for each department:</p>
<div class="contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950">
<div class="flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none">sql</div>
<div class="sticky top-9 md:top-[5.75rem]">
<div class="absolute bottom-0 right-2 flex h-9 items-center">
<div class="flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary">
<pre class="language-php"><code>SELECT department, MIN(salary) AS lowest_salary, MAX(salary) AS highest_salary
FROM employees
GROUP BY department;
</code></pre>
</div>
</div>
</div>
</div>
<h4>5. <strong>Using MIN and MAX with Date Columns</strong></h4>
<p>Find the earliest and latest order dates:</p>
<div class="contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950">
<div class="flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none">sql</div>
<div class="sticky top-9 md:top-[5.75rem]">
<div class="absolute bottom-0 right-2 flex h-9 items-center">
<div class="flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary">
<pre class="language-php"><code>SELECT MIN(order_date) AS earliest_order, MAX(order_date) AS latest_order
FROM orders;
</code></pre>
</div>
</div>
</div>
</div>
<hr />
<h3>Practical Use Cases</h3>
<ol>
<li>
<p><strong>Finding Data Ranges</strong>:</p>
<ul>
<li>Determine the oldest and youngest employees in a company.</li>
<li>Identify the price range for products.</li>
</ul>
</li>
<li>
<p><strong>Identifying Outliers</strong>:</p>
<ul>
<li>Find the highest and lowest grades in an exam.</li>
</ul>
</li>
<li>
<p><strong>Group-Specific Analysis</strong>:</p>
<ul>
<li>Analyze the highest and lowest sales in each region.</li>
</ul>
</li>
</ol>
<hr />
<h3>Performance Tips</h3>
<ul>
<li>Ensure columns used with <strong><code>MIN()</code></strong> and <strong><code>MAX()</code></strong> are indexed for better query performance.</li>
<li>Use filters (<code>WHERE</code>) to narrow down data before applying aggregate functions.</li>
</ul>
<hr />
<h3>Example with Multiple Functions</h3>
<p>Find the highest, lowest, and average salary for employees in each department:</p>
<div class="contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950">
<div class="flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none">sql</div>
<div class="sticky top-9 md:top-[5.75rem]">
<div class="absolute bottom-0 right-2 flex h-9 items-center">
<div class="flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary">
<pre class="language-php"><code>SELECT department, 
       MIN(salary) AS lowest_salary, 
       MAX(salary) AS highest_salary, 
       AVG(salary) AS average_salary
FROM employees
GROUP BY department;
</code></pre>
</div>
</div>
</div>
</div>
<hr />
<h3>&nbsp;</h3>
</div>
</div>
</div>
</div>
</div>
</div>

Web Technology View More

MySQL MIN and MAX

Learn Ansible

Learn HTML

Learn Angular 3

Learn PHP

Learn Angular 2.0

Learn Python

Learn C# Sharp

Learn CSS

Learn Node Js

Learn JQuery Framework

Learn SQL Tutorial

Learn MySql

Learn PHP 7.1

Learn Angular 3

Learn Angular 2

Learn HTML5

Learn Angular 2

Learn Angular 3.0

Learn Bootstrap 3

Learn Bootstrap 4

Learn Bootstrap 5

Learn JQuery Tutorials