Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // Write a SQL query to find the names and salaries of the employees that take the minimal salary in the company.
- var context = new TelerikAcademyContext();
- var minSalary = context.Employees.OrderBy(e => e.Salary).First();
- var result = context.Employees
- .Where(f => f.Salary == minSalary.Salary)
- .Select(
- g => new
- {
- g.FirstName,
- g.LastName,
- }).ToList();
- foreach (var r in result)
- {
- Console.WriteLine($"{r.FirstName} {r.LastName}");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement