从字段中查找最大值和最小值

function findMaxAndMin(arr) {
  let max = arr[0];
  let min = arr[0];
  
  for (let i = 1; i < arr.length; i++) {
    if (arr[i] > max) {
      max = arr[i];
    }
    
    if (arr[i] < min) {
      min = arr[i];
    }
  }
  
  return { max, min };
}

const numbers = [5, 2, 9, 1, 7];
const result = findMaxAndMin(numbers);
console.log(result.max); // 输出最大值：9
console.log(result.min); // 输出最小值：1

SELECT MAX(column_name) AS max_value, MIN(column_name) AS min_value FROM table_name;

SELECT MAX(column_name), MIN(column_name) FROM table_name;