We can get and return using CASE statement
in SQL Server
i.e.
CASE
WHEN STARTDATE >= ENDDATE
THEN STARTDATE
ELSE ENDDATE
END
SELECT
EXCEPTIONID,
(CASE
WHEN INSERTEDDATE >= UPDATEDDATE
THEN INSERTEDDATE
ELSE UPDATEDDATE
END) AS EXCEPTION_DATE
FROM [DBO].[APPEXCEPTION]