Select all value except min value and add corresponding min value in another column
Consider this table:
id|text|
–|–|
101|Black|
102|Black|
103|White|
104|White|
105|White|
Consider this table:
id|text|
–|–|
101|Black|
102|Black|
103|White|
104|White|
105|White|