SELECT ID,(SELECT MIN([DATE]) FROM (VALUES(col1),(col2),(col3)) x([DATE])) MINDATE  FROM Tablename

 

 

Advertisements