Retrieve Next Employee Salary Using LEAD

Question

Find the next employee's salary using a window function.

Accepted Answer

```sql
SELECT 
    id, 
    salary, 
    LEAD(salary) OVER (ORDER BY id) AS next_salary
FROM employees;
```

This query uses the `LEAD()` window function to retrieve the value of the "salary" column from the subsequent row, ordered by the "id" column, within the "employees" table.