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

by


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

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