Posted by J.O. Aho on 03/08/07 18:16

badboy wrote:
> Hi guys,
>
> I have two fields which I need to compare and show them if the diference is
> 80% or more?
> Can somebody tell me how to this???


SELECT * FROM table_name WHERE (column_A * 0.2 >= column_B) OR (column_B * 0.2
>= column_A)


--

//Aho

[Back to original message]