Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: Equations in ORDER BY statements
04-20-2013, 02:16 PM #1
- Join Date
- May 2007
- Thanked 0 Times in 0 Posts
Equations in ORDER BY statements
Is this possible ? And would it slow down the server with a query on a table with around 10,000 entries ?
My query is currently
SELECT title, number1, number2 ORDER BY number1
i would like to do something like this
SELECT title, number1, number2 ORDER BY (number1 + (number2 *100))
04-21-2013, 03:29 AM #2
Not to ask a really really silly question, but...
WHY did you not simply TRY it? Would have taken much less time than waiting here for an answer.
Yes, you can do that.
With only 10,000 records in the table, I wouldn't expect to see any serious performance hit. Probably not even a noticeable one.
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.