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

Saturday, August 17, 2019

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


 


2 comments:

  1. 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

Search This Blog