In a table called Item there are several items. Item with same can be there such as chocolate, toffee but they have a different Item code. How can I find the Same item with maximum and minimum values.?(That is chocolate with with maximum and minimum prize). I thank you in advanced.
Here they come Code: Select * from chocolate where price = (Select max(price) from chocolate) Code: Select * from chocolate where price = (Select min(price) from chocolate)
