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.
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