finding maximum and minimum in a column

nmh's Avatar, Join Date: Sep 2007
nmh
Go4Expert Member
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.
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
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)
nmh's Avatar, Join Date: Sep 2007
nmh
Go4Expert Member
shabbir
Thanks a lot
cheers