从多个列中选择最小值并计算其总和的最佳方法是什么？

SELECT SUM(MIN_VALUE) AS total_min
FROM (
    SELECT MIN(column1, column2, column3) AS MIN_VALUE
    FROM your_table
    GROUP BY some_key
) subquery;

import pandas as pd

# 假设df是你的DataFrame
df['min_value'] = df[['column1', 'column2', 'column3']].min(axis=1)
total_min_sum = df['min_value'].sum()

import java.util.List;

// 假设data是一个包含多个对象的列表，每个对象有column1, column2, column3属性
int totalMinSum = data.stream()
    .mapToInt(item -> Math.min(Math.min(item.getColumn1(), item.getColumn2()), item.getColumn3()))
    .sum();

const data = [
    { column1: 5, column2: 3, column3: 8 },
    { column1: 10, column2: 1, column3: 4 },
    // 更多数据...
];

const totalMinSum = data.reduce((sum, item) => {
    const minValue = Math.min(item.column1, item.column2, item.column3);
    return sum + minValue;
}, 0);