Azure SQL now supports greatest() function to find out the greatest value among multiple columns thereby preventing from writing cumbersome CASE WHEN statements in the query.
I need to use this in a LINQ query's order by clause. I have 4 date columns and I need to order the results based on the maximum of these. Can someone please point me how can this be achieved? cc: @DuaneArnold-0443