Compare two columns in a table in the data size, how to write code?

CodePudding user response:

 select case when c1 & gt;=c2 then 1 else 0 end as result 
The from tableName