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 the minimum and maximum values for the Price column. Here is how the query works: Want to learn more about …