Min and Max Aggregate Functions in TSQL
Here is a sample query using the MIN and MAX functions in T-SQL: This query selects the minimum and maximum values for the Price column from the Products table. The results of the query will be a single row containing …