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
Sunday, June 19, 2016
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
The query above gets the highest and lowest prices for the Products table in the Northwind database
The query above gets the highest and lowest prices for the Products table in the Northwind database
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment