Learn SQL: MAX and MIN aggregate functions

Today, we will take it further and tell you about MIN and MAX aggregate functions. As you can easily guess from their names, they are designed to find the smallest and largest values in the selected column of the table.

If you apply the MAX or MIN function to a column of numeric type, you will get the largest or smallest number in that column as a result, respectively. It is worth noting that these functions can also be used on columns containing strings. However, this topic is full of nuances and deserves a separate discussion, and today we will talk about the use of MAX and MIN functions for numeric values, which is a common practice.

--
How to download and install DBeaver: https://www.youtube.com/watch?v=NWTX0W-WgzE
The whole educational playlist: https://www.youtube.com/playlist?list=PLkh7-EMxQiV2DAiruEWgh-i4jreuyX1rP
--
Try DBeaver PRO for free (14 days trial): https://dbeaver.com/trial/
--
Contact us:

E-mail: [email protected]
GitHub: https://www.github.com/dbeaver
LinkedIn: https://www.linkedin.com/company/dbeaver
Twitter: https://twitter.com/dbeaver_news
Facebook: https://www.facebook.com/DBeaverCorporation/
--
Subscribe to our channel to get more interesting videos about DBeaver and the database world!

Тэги:

#dbeaver #dbeaver_community #sql_beginners #sql_tutorial #sql_tutorial_dbeaver #why_we_need_select_distinct #aggregate_functions #aggregate_functions_sql #aggregate_function_example #group_by #group_by_sql #group_by_example #group_by_dbeaver #count_function #count_dbeaver #count_function_dbeaver #group_panel_dbeaver #count_function_example #count_sql_tutorial #group_by_tutorial #Learn_SQL #min_sql #max_sql #min_max_aggregate #min_max_example

Скачать видео