SQL MAX of multiple columns?

by

Here is another nice solution for the Max functionality using T-SQL and SQL Server

SELECT [Other Fields],
  (SELECT Max(v) 
   FROM (VALUES (date1), (date2), (date3),...) AS value(v)) as [MaxDate]
FROM [YourTableName]

Values is the Table Value Constructor.

“Specifies a set of row value expressions to be constructed into a table. The Transact-SQL table value constructor allows multiple rows of data to be specified in a single DML statement. The table value constructor can be specified either as the VALUES clause of an INSERT … VALUES statement, or as a derived table in either the USING clause of the MERGE statement or the FROM clause.”

More Related Contents:

  1. SQL where clause odd behavior [closed]
  2. How do I obtain a Query Execution Plan in SQL Server?
  3. How do I escape a single quote in SQL Server?
  4. Simple way to transpose columns and rows in SQL?
  5. Only inserting a row if it’s not already there
  6. When should I use CROSS APPLY over INNER JOIN?
  7. SQL Server Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, =
  8. Remove Identity from a column in a table
  9. Using the result of an expression (e.g. Function call) in a stored procedure parameter list?
  10. Formatting Numbers by padding with leading zeros in SQL Server
  11. When no ‘Order by’ is specified, what order does a query choose for your record set?
  12. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  13. For Nvarchar(Max) I am only getting 4000 characters in TSQL?
  14. How do I create a foreign key in SQL Server?
  15. How do I group on continuous ranges
  16. join comma delimited data column
  17. Need to list all triggers in SQL Server database with table name and table’s schema
  18. Count based on condition in SQL Server
  19. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  20. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  21. Best equivalent for IsInteger in SQL Server
  22. Syntax of for-loop in SQL Server
  23. How to correctly insert newline in nvarchar [duplicate]
  24. How do you copy a record in a SQL table but swap out the unique id of the new row?
  25. Using IF ELSE statement based on Count to execute different Insert statements
  26. SQL – Call Stored Procedure for each record
  27. SQL Server SELECT INTO @variable?
  28. WITH CHECK ADD CONSTRAINT followed by CHECK CONSTRAINT vs. ADD CONSTRAINT
  29. Select a column if other column is null
  30. Sql Server : How to use an aggregate function like MAX in a WHERE clause

Leave a Comment