Tech Junkie Blog - Real World Tutorials, Happy Coding!: SQL: MAX() And MIN() Aggregate Functions

Thursday, September 2, 2021

SQL: MAX() And MIN() Aggregate Functions

The MAX() function gets the highest value in the specified column, and the MIN() function gets the lowest value in the specified column

SELECT MAX(UnitPrice) AS HighestPrice, MIN(UnitPrice) AS LowestPrice
FROM Products

The query above gets the highest and lowest prices for the Products table in the Northwind database


 

 Previous: SQL: DATEPART Function


 at

5 comments:

  1. UnknownAugust 12, 2019 at 4:59 AM

    I am new here

    ReplyDelete
  2. carisAugust 28, 2019 at 6:57 AM

    Ace4sure is the website that deals in preparation material for the exam for many years. According to my exposure and research, this is the right platform where you can get exact 220-1001 Dumps.

    ReplyDelete
  3. InnomaticsSeptember 3, 2021 at 7:29 AM

    Data science course in hyderabad
    we provide classroom training on IBM certified Data Science at hyderabad for the individuals who believe hand-held training. We teach as per the Indian Standard Time (IST) with In-depth practical Knowledge on each topic in classroom training, 80 – 90 Hrs of Real-time practical training classes. There are different slots available on weekends or weekdays according to your choices.

    ReplyDelete
  4. keven johnOctober 13, 2022 at 6:33 AM

    SQL is a good data base everu backend developer have used this database.If you are looking to buy an online business management research topics service.You can easily make a call.

    ReplyDelete
  5. Emma StoneSeptember 2, 2024 at 2:44 PM

    This comment has been removed by the author.

    ReplyDelete