How to get column name which having max value in sql server

Question

How to get column name which having max value in sql server- Expected output is-column name with Value.

Nitin Sontakke · Answer

Hummm. Complicated... The following link will give you max of two (or more) columns, but not the name. https://www.sqlservercentral.com/Forums/Dialogs/PostDetails.aspx?PostID=1348803 With my knowledge, a dirty code with a cursor would probably be required.

Shahriar Nikkhah · Answer

Is this MAX as in [datatype] with the MAX length or max value from the [data]?? I see that Nitin has the right answer, but if the question is datatype with the MAX use SELECT TableName = '[' + OBJECT_NAME([object_id]) + ']' , columnName = '[' + [ name ] + ']' , DataType = TYPE_NAME ([system_type_id]) --, * FROM sys.columns -- OR you might use sys.all_columns WHERE 1 = 1 AND [max_length] = -1 ORDER BY OBJECT_NAME(object_id) , [column_id]

Nitin Sontakke · Answer

Your question isn't quite detailed enough and is open for misinterpretation. Please provide mode details. You would obviously know the column name while write the query so what is the point of finding out it's name. You already know it. For example: select max([salary]) from [dbo].[tblEmployee] So, in above case, the column name is [Salary]. Simple, isn't it? Please give detailed information about your question.

How to get column name which having max value in sql server

Answers (3)