[nmh]

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]

Here they come

Select * from chocolate where price = (Select max(price) from chocolate)

Select * from chocolate where price = (Select min(price) from chocolate)

[nmh]

shabbir
Thanks a lot
cheers