如何使用C#从SQL Server表中获取几个最大值和最小值

string connectionString = "your_connection_string";
string query = "SELECT MAX(value) AS max_value, MIN(value) AS min_value FROM table_name";

using (SqlConnection connection = new SqlConnection(connectionString))
{
    SqlCommand command = new SqlCommand(query, connection);
    connection.Open();
    
    SqlDataReader reader = command.ExecuteReader();
    if (reader.Read())
    {
        decimal maxValue = reader.GetDecimal(reader.GetOrdinal("max_value"));
        decimal minValue = reader.GetDecimal(reader.GetOrdinal("min_value"));
        
        // 在这里可以对获取到的最大值和最小值进行处理
    }
    
    reader.Close();
}