[javamad]

Hi
Very new to SQL so apologies.
Say I have a table called results with 3 columns of data (record id, resultA and resultB)

table results
record, A , B
------------------
1 , 5 , 8
2 , 7 , 3
3 , 4 , 4
4 , 5 , 8
:
n , 8 , 1

I would like to create a formula that outputs a result query that ranks the records based on the formula A/B

Could someone give me a hand in figuring this out please
Many thanks

This post has been edited by javamad: 25 January 2010 - 04:33 AM

[aadam21]

Hi,

Not sure if this is what you're looking for exactly, but from your question, I took it to mean you want to order the results of your table based on column A and B. If so, use order by A, B in your select statement. This will order the results (ascending by default) by column A, then by column B.

[xerxes333]

@aadam21 I think he(she) wants the results of the calculation A/B sorted ascending. In which case you would want to execute the calculation A/B in the query and sort based on the calculation. A simple example would be

SELECT A/B as calc FROM results ORDER BY calc ASC