var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Simple question about a query...
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?
Short answer, no.
You could try using the domain functions (dmin and dmax) and see if there's any performance gain, I'm not sure how they compare to a standard query...
Teddy (not in the dodgey sense) I love you.
Now all I have to do is convince my lecturer who marked me down for doing that , thanks