MySQL Forums
Forum List  »  Newbie

Sorting values in multiple columns
Posted by: Harland Oracle
Date: May 07, 2023 08:50AM

I need mySQL code to:
update table batting_life162
set pos1 = to the highest value contained in the following columns: g_c/(yrs-2), or g_1b/(yrs-2), or g_2b/(yrs-2), or g_3b/(yrs-2), or g_ss/(yrs-2), or g_lf/(yrs-2), or g_cf/(yrs-2), or g_rf/(yrs-2), or g_dh/(yrs-2)
concat that value with "-" and concatenate with
"2" if the column containing the highest value is "g_c"
"3" if the column containing the highest value is "g_1b"
"4" if the column containing the highest value is "g_2b"
"5" if the column containing the highest value is "g_3b"
"6" if the column containing the highest value is "g_ss"
"7" if the column containing the highest value is "g_lf"
"8" if the column containing the highest value is "g_cf"
"9" if the column containing the highest value is "g_rf"
"10" if the column containing the highest value is "g_dh"

set pos2 = to the 2nd highest value contained in g_c/(yrs-2), or g_1b/(yrs-2), or g_2b/(yrs-2), or g_3b/(yrs-2), or g_ss/(yrs-2), or g_lf/(yrs-2), or g_cf/(yrs-2), or g_rf/(yrs-2), or g_dh/(yrs-2)
and concatenate that value with "-" and concatenate with
"2" if the column containing the 2nd highest value is "g_c"
"3" if the column containing the 2nd highest value is "g_1b"
"4" if the column containing the 2nd highest value is "g_2b"
"5" if the column containing the 2nd highest value is "g_3b"
"6" if the column containing the 2nd highest value is "g_ss"
"7" if the column containing the 2nd highest value is "g_lf"
"8" if the column containing the 2nd highest value is "g_cf"
"9" if the column containing the 2nd highest value is "g_rf"
"10" if the column containing the 2nd highest value is "g_dh"

set pos3 = to the 3rd highest value contained in g_c/(yrs-2), or g_1b/(yrs-2), or g_2b/(yrs-2), or g_3b/(yrs-2), or g_ss/(yrs-2), or g_lf/(yrs-2), or g_cf/(yrs-2), or g_rf/(yrs-2), or g_dh/(yrs-2)
and concatenate that value with "-" and concatenate with
"2" if the column containing the 3rd highest value is "g_c"
"3" if the column containing the 3rd highest value is "g_1b"
"4" if the column containing the 3rd highest value is "g_2b"
"5" if the column containing the 3rd highest value is "g_3b"
"6" if the column containing the 3rd highest value is "g_ss"
"7" if the column containing the 3rd highest value is "g_lf"
"8" if the column containing the 3rd highest value is "g_cf"
"9" if the column containing the 3rd highest value is "g_rf"
"10" if the column containing the 3rd highest value is "g_dh"

set pos4 = to the 4th highest value contained in g_c/(yrs-2), or g_1b/(yrs-2), or g_2b/(yrs-2), or g_3b/(yrs-2), or g_ss/(yrs-2), or g_lf/(yrs-2), or g_cf/(yrs-2), or g_rf/(yrs-2), or g_dh/(yrs-2)
and concatenate that value with "-" and concatenate with
"2" if the column containing the 4th highest value is "g_c"
"3" if the column containing the 4th highest value is "g_1b"
"4" if the column containing the 4th highest value is "g_2b"
"5" if the column containing the 4th highest value is "g_3b"
"6" if the column containing the 4th highest value is "g_ss"
"7" if the column containing the 4th highest value is "g_lf"
"8" if the column containing the 4th highest value is "g_cf"
"9" if the column containing the 4th highest value is "g_rf"
"10" if the column containing the 4th highest value is "g_dh"

where yrs>2

include all functions, etc. I need to write into a script that i will execute all at once

Options: ReplyQuote


Subject
Written By
Posted
Sorting values in multiple columns
May 07, 2023 08:50AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.