If you want to return the maximum value of the numeric field then you use max function
syntax:
select max(price) as maximum price from product;
when you run the above SQL query, SQL will return the maximum value of the products table.
syntax:
select max(price) as maximum price from product;
when you run the above SQL query, SQL will return the maximum value of the products table.
No comments:
Post a Comment