Find Max Value From Multiple Columns In Table Using SQL

Replies

• 

  Abhishek Rawal

  Kindly elaborate the question.With the Title Name & details you've given, we can't really understand the query.
• 

  Kaustubh Katdare

  #-Link-Snipped-# : Please avoid making assumptions that the reader will know what you want. Right now, we don't know if you are talking about MySQL or Excel or some other type of database and what kind of data is present in the table.
  
  Take a minute to elaborate your questions so that there's no room for assumptions and the reader exactly understands your question. That helps others help you.
• 

  karan20m

  it is for SQL
• 

  Kaustubh Katdare

  ELECT
      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

  Source: #-Link-Snipped-#
• 

  karan20m

  thnx
• 

  Neeraj Sharma

  karan20m

  thnx

  Please avoid using SMS languages and write complete words.
  
  Can you also elaborate your use case for this requirement? It will help us better understanding your needs and in turn help you efficiently.