Swagat P

Swagat P

  • 1.6k
  • 310
  • 42.5k

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

Brought to you by: JavaScript SDK for Bold BI dashboard and analytics embedding. Free trial.

Answers (4)