Swagat P

Swagat P

  • 1k
  • 374
  • 68.1k

column name which contains max Value in sql server table.

Apr 15 2018 3:41 AM
I have a color table with columns Code,Red ,Black, Green with values Cd1,100 ,200,300 . I want a sql query which will show the column name having highest value. Expected Output - Green 300

Answers (4)