SQL MAX of multiple columns?

Question

SQL MAX of multiple columns?

How do you return 1 value per row of the max of several columns:

TableName

[Number, Date1, Date2, Date3, Cost]

I need to return something like this:

[Number, Most_Recent_Date, Cost]

Query?

sql-server sql

4 years ago by vishaljlf39

3 Answers

Login / Signup to Answer the Question.

Login Signup

**akshay1995** · Answer 1 · 2021-06-19T13:06:56

Well, you can use the CASE statement:



SELECT

    CASE

        WHEN Date1 >= Date2 AND Date1 >= Date3 THEN Date1

        WHEN Date2 >= Date1 AND Date2 >= Date3 THEN Date2

        WHEN Date3 >= Date1 AND Date3 >= Date2 THEN Date3

        ELSE                                        Date1

    END AS MostRecentDate

**sandhya6gczb** · Answer 2 · 2021-06-21T12:23:46

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]

**RoliMishra** · Answer 3 · 2021-06-22T13:21:48

RoliMishra

If you're using MySQL, you can use

SELECT GREATEST(col1, col2 ...) FROM table

4 years ago

C TUTORIAL

C PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

C++ TUTORIAL

C++ PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

PYTHON TUTORIAL

PYTHON HOW TOS

INTERVIEW TESTS

EXECUTE CODE

JAVA TUTORIAL

JAVA CODE EXAMPLES

SPRING TUTORIAL

MORE IN JAVA

COMPUTER ARCHITECTURE

COMPUTER NETWORK

OPERATING SYSTEM

DBMS & SQL

PL/SQL

MongoDB

EXECUTE SQL

ANDROID DEVELOPMENT

GO LANGUAGE

LINUX

DOCKER

HTML TAGS (A to Z)

CSS REFERENCES

SASS/SCSS

KOTLIN

GAME DEVELOPMENT

PHP

GIT GUIDE

JAVASCRIPT

ADVANCED DSA

SQL MAX of multiple columns?

3 Answers

Login / Signup to Answer the Question.