Simple query question
Ok I have a table called SaleProperty which includes house prices
Now I want to output the property with the highest value and the lowest value so i came up with:
WHERE price = (SELECT MIN(price) FROM SaleProperty)
price = (SELECT MAX(price) FROM SaleProperty);
Is there a better way of doing this? i.e. with one sub query instead of two?
Note: this is in MS Access XP 2002
select min(price) as MinPrice, max(price) as MaxPrice