Greatest value of multiple columns with column name?

by

You can use GREATEST function to find the maximum value among all columns:

SELECT @var_max_val:= GREATEST(col1, col2, col3, ...) AS max_value,
       CASE @var_max_val WHEN col1 THEN 'col1'
                         WHEN col2 THEN 'col2'
                         ...
       END AS max_value_column_name
FROM table_name
WHERE ...

More Related Contents:

  1. Which DB technology is sued to solve the following search issue? [closed]
  2. MySQL pivot row into dynamic number of columns
  3. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  4. Count the number of occurrences of a string in a VARCHAR field?
  5. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  6. MySQL – Operand should contain 1 column(s)
  7. How to get the difference in years from two different dates?
  8. Restore table structure from frm and ibd files
  9. mysql pivot/crosstab query
  10. MySQL: Split comma separated list into multiple rows
  11. Most efficient way to get table row count
  12. UNION query with codeigniter’s active record pattern
  13. Mysql Convert Column to row (Pivot table )
  14. Merge two tables in one SQL query and make the date values unique
  15. Remove Primary Key in MySQL
  16. Get most recent row for given ID
  17. Is merge statement available in MySQL
  18. Mysql covering vs composite vs column index
  19. MYSQL syntax not evaluating not equal to in presence of NULL
  20. Mysql insert random datetime in a given datetime range
  21. MySql – Way to update portion of a string?
  22. MYSQL select DISTINCT values in two columns
  23. Using reserved words in column names
  24. MySQL INNER JOIN select only one row from second table
  25. Storing IPv6 Addresses in MySQL
  26. Insert/ Update random date in MySQL
  27. Replace null with 0 in MySQL
  28. Get total hours worked in a day mysql
  29. Convert SQL Server query to MySQL [duplicate]
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment