SQL

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???

Thanks

Re: SQL

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