|
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
Navigation:
[Reply to this message]
|