Results 1 to 2 of 2
Thread: Simple query question
Jan 19, 2005, 09:01 #1
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 2002Laws are like sausages. You have much more respect for them if you haven't actually seen how they're made.