Saturday, August 1, 2015

SQL tutorial - lesson 16 - Min function

If you want to return the min value of the selected numeric field then you use min function

syntax:

select min(price) as minimum price from products;

when you run the above SQL query, SQL will return the minimun price of the product in the products table.

No comments:

Post a Comment