The query above gets the highest and lowest prices for the Products table in the Northwind database
SELECT MAX(UnitPrice) AS HighestPrice, MIN(UnitPrice) AS LowestPrice
FROM Products
Saturday, March 7, 2015
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment