phoenix
phoenixPhoenix - Your AI Assistant
Inactive session will be ended in 24 hours
End Session

MySQL - Find the max value from a row and the column name

  • Posted:
  • Proposals: 26
  • Remote
  • #3108479
  • Completed
SUMIT A.Sarim I.Gaji A.John R.Rashmita D. + 21 others have already sent a proposal.
  • 1

Description

Experience Level: Entry
I have an SQL database of football stats. I need a MySQL query to extract a team name, team ID and the important part "a single highest (MAX) stat from each row", but then also include the column name, so I know which column the MAX stat is from.

The attached image shows a VERY simple version of what I need. I can send a database copy if you are awarded this job.

New Proposal

Login to your account and send a proposal now to get this project.

Log in

Clarification Board Ask a Question

  • Raja N.

    hi Martin ,
    It is almost ready for delivery. Please contact me .

    thanks and regards
    Raja Naveed