A community for students.
Here's the question you clicked on:
 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.
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

anonymous
 5 years ago
Best ResponseYou've already chosen the best response.0Im looking for an SQL statement as a solution, I have a solution in a spreadsheet program.

anonymous
 5 years ago
Best ResponseYou've already chosen the best response.0This 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
Ask your own question
Sign UpFind more explanations on OpenStudy
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
 Engagement 19 Mad Hatter
 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.