使用LINQ获取SQL数据集的最大排序顺序的所有变量

using System;
using System.Linq;

public class Program
{
    public static void Main()
    {
        // 假设有一个名为"employees"的SQL数据表，包含"id"和"salary"两列

        // 创建LINQ查询，按照"salary"降序排序
        var query = from employee in employees
                    orderby employee.salary descending
                    select employee;

        // 获取最大排序顺序的所有变量
        var maxSalaryEmployees = query.Take(1);

        // 输出结果
        foreach (var employee in maxSalaryEmployees)
        {
            Console.WriteLine("ID: " + employee.id + ", Salary: " + employee.salary);
        }
    }
}