[Solved] I want to retrieve max value from two column – SQL table

by

[ad_1]

You could try using UNION ALL for build a unique column result and select the max from this

select max(col) 
from (
select col1 col
from  trans_punch
union all
select col2
from  trans_punch) t

[ad_2]

solved I want to retrieve max value from two column – SQL table