A community for students.

Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing

anonymous

  • 5 years ago

If it is possible, how to select the value of the largest numerical field of the same record / row (as opposed to the largest value in the same column). Something like select id, max (f1,f2,f3,f4) as f from table; Where f would give the largest number of those four fields ... This is just an example what Id like to have it actually does not work.

  • This Question is Closed
  1. anonymous
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Im looking for an SQL statement as a solution, I have a solution in a spreadsheet program.

  2. anonymous
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    This does the job Select max(val) From ( Select max(f1) as val FROM table union Select max(f2) as val FROM table union Select max(f3) as val FROM table union Select max(f4) as val FROM table ) subquery

  3. Not the answer you are looking for?
    Search for more explanations.

    • Attachments:

Ask your own question

Sign Up
Find more explanations on OpenStudy
Privacy Policy

Your question is ready. Sign up for free to start getting answers.

spraguer (Moderator)
5 → View Detailed Profile

is replying to Can someone tell me what button the professor is hitting...

23

  • Teamwork 19 Teammate
  • Problem Solving 19 Hero
  • You have blocked this person.
  • ✔ You're a fan Checking fan status...

Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.

This is the testimonial you wrote.
You haven't written a testimonial for Owlfred.