CareerCup

using window function:
select employee, salary, lead(salary) over(partition by department order by salary) as next_salary, department
	from table
using scalar-subquery:
select employee, salary, (select min(salary) from table t2 where t2.department=t1.department and t2.salary>t1.salary) as next_salary, department
	from table t1

SELECT Employee,Salary,
LEAD(salary,1) OVER (PARTITION BY Department ORDER BY Department) AS Next_Sal
Department
FROM Employee
GROUP BY 1,2,4
ORDER BY Employee

SELECT Employee,Salary,
       LEAD(salary,1) OVER (PARTITION BY Department ORDER BY Department) AS Next_Salary
       Department
FROM `amazoninterviewquestions.Business_Intelligence.Rough_Work` 
GROUP BY 1,2,4
ORDER BY Employee

SELECT Employee,Salary,
       LEAD(salary,1) OVER (PARTITION BY Department ORDER BY Department) AS Next_Salary
       Department
FROM `amazoninterviewquestions.Business_Intelligence.Rough_Work` 
GROUP BY 1,2,4
ORDER BY Employee

select
e1.first_name,
e1.salary,
(select e2.salary from employees e2
where d.id=e2.department_id
and e2.salary > e1.salary
order by e2.salary
limit 1) as "next_salary",
d.name
from employees e1
join departments d on d.id=e1.department_id

SELECT
Employee
,Salary
,LEAD(Salary,1) OVER (PARTITON BY Department ORDER BY Department) AS Next_Salary
,Department
FROM table
GROUP BY 1,2,3
ORDER BY Employee

SELECT
Employee
,Salary
,LEAD(Salary,1) OVER ( PARTITION BY Department ORDER BY Department) AS Next_highest_salary
,Department
FROM source_table
GROUP BY 1,2,4
ORDER BY Employee

Create a table for employee with fields I'd,name, department,salary, address and display data records in tables formate