MIN MAX

[karr4]

When doing the min/max exercises  , it will list the price. how would i find the product name?

[Sherin]

You want to try this

create table product
(
  p_id int primary key,
  prod_name  varchar(20),
  price varchar(5)
  );

insert into product values(1,"Milk",100);
insert into product values(2,"Buttermilk",120);
insert into product values(3,"Paneer",80);
insert into product values(4,"Cheese",150);
insert into product values(5,"Ghee",700);

select * from product

You can get the max price from table

SELECT prod_name, MAX(price)
FROM product
GROUP BY prod_name;

You can get min price from table

SELECT prod_name, MIN(price)
FROM product
GROUP BY prod_name;