sql retrieve only max and min value

[Anon]

I have a table full of prices of crapola, and in a query, I would like to retrieve only two field entries -
the one which has the highest price
the one that has the lowest price

is this at all possible in a single query without having to build another table to store those values?

[Anon]

Use the database's MAX and MIN functions.