Round #788

Find the second-highest salary in an employees table.

```csharp using System; using System.Data; using System.Linq; public class Program { public static void Main() { // Create a sample DataTable DataTable dt = new DataTable(); dt.Columns.Add("Name", typeof(string)); dt.Columns.Add("Salary", typeof(int)); dt.Rows.Add("John", 50000); dt.Rows.Add("Alice", 60000); dt.Rows.Add("Bob", 40000); dt.Rows.Add("Mary", 70000); dt.Rows.Add("Peter", 45000); // Find the second-highest salary var secondHighestSalary = dt.AsEnumerable() .OrderByDescending(r => r.Field<int>("Salary")) .Select(r => r.Field<int>("Salary")) .Distinct() .Skip(1) .FirstOrDefault(); Console.WriteLine(secondHighestSalary); } } ```

```csharp using System; using System.Data; using System.Linq; public class Employee { public int Id { get; set; } public string Name { get; set; } public decimal Salary { get; set; } } public class Program { public static decimal FindSecondHighestSalary(Employee[] employees) { if (employees == null || employees.Length < 2) return 0; var distinctSalaries = employees.Select(e => e.Salary).Distinct().OrderByDescending(s => s).ToArray(); if (distinctSalaries.Length < 2) return 0; return distinctSalaries[1]; } public static void Main() { Employee[] employees = new Employee[] { new Employee { Id = 1, Name = "John", Salary = 50000 }, new Employee { Id = 2, Name = "Alice", Salary = 60000 }, new Employee { Id = 3, Name = "Bob", Salary = 40000 }, new Employee { Id = 4, Name = "Charlie", Salary = 60000 }, }; decimal secondHighestSalary = FindSecondHighestSalary(employees); Console.WriteLine(secondHighestSalary); } } ```