[SOLVED] ORDER BY formula

[abdfahim]

Is it possible in SQL to run query ORDER BY formula, for example .......... ORDER BY (ColumnA * ColumnB) ?

[Xurion]

Your formula makes no sense. Column A multiplied by column B? Or are you using * in the context like you would in SELECT * FROM ...?

 

You can use: SELECT * FROM t1 ORDER BY key1, key2;

[abdfahim]

well, if i use ORDER BY key1,key2, then it will order the result first by key1, then by key2. But i want to order it by the result of key1 multiply key2. So, i was asking is there any other way other than including another column which will store key1 multiply key2 and then order by that column?

[fenway]

Your formula makes no sense.

I disagree.... you can order by anything you want.`

[Xurion]

so if I put 'ORDER BY 135', what would happen?

[kbh43dz_u]

so if I put 'ORDER BY 135', what would happen?

Well you can order by 135... but the result will be the same than like without 

[PFMaBiSmAd]

Did you try that, you would get a mysql syntax error if your table did not have a column named 123

[kbh43dz_u]

no it works without an error. don't forgett '!

 

...ORDER BY '135'

 

(i had nothing like 135 in my database)

[PFMaBiSmAd]

ORDER BY 135, the question that was asked, is not the same as ORDER BY '135'

[kbh43dz_u]

(i know, i told you. you can but it dosen't make sense.)

[abdfahim]

guys guys ... i think we are going away from the objective [] ........... my question was, like I have a table

Person   columnA   columnB

A             10          55
B              8           61
C             15          35

 

Now I want to arrange the table with the Person with highest (columnA multiply columnB) at the top, and so ... Is it possible without adding another column?

 

[kbh43dz_u]

Okay, sorry... back to the topic:

 

 

Here is what you (probably) need:

 

SELECT `theFieldINeed`, `fieldOne`*`fieldTwo` as orderby FROM `table` ORDER BY orderby

 

 

Explanation: theFieldINeed is the result what I want.

With 'fieldOne'*'fieldTwo' i combine (multiple) the two fields I want to order by and defin them as orderby (you can call it whatever you want)

From 'table' is clear and you order by oderby (in my case or the word you choose)

 

 

Give it a try

[fenway]

so if I put 'ORDER BY 135', what would happen?

Well you can order by 135... but the result will be the same than like without 

Actually, it will order by the 135th column in the select list; 135 wasn't quoted in your example.

 

 

Is it possible in SQL to run query ORDER BY formula, for example .......... ORDER BY (ColumnA * ColumnB) ?

Did you actually try this?  It will work.

 

[abdfahim]

thankx vamosbenedikt ... i got it ...

 

thanx ... fenway .. the thing is I tried that but it didn't work b4 ... but after getting ur post, I again tried and it works !!!! I must have done something else wrong.

 

Sorry for the inconvenience and appreciate ur help.