Comments / Profile of DocSportello / Habr

@DocSportello

User

ProfileArticlesPostsNewsComments4

DocSportello Jul 15 2024 at 09:12

Спасибо, не заметил что пропустил desc в order by

Look

DocSportello Jul 15 2024 at 07:17

Больше нравится вариант с оконной функцией, компактно получилось)

/* 1 */
select *
from public.employees
where salary in (
    select max(salary)
    from public.employees
    group by department_id
);

/* 2 */
select *
from (
    select *, dense_rank() over(partition by department_id order by salary) as rank
    from public.employees
) as t
where t.rank = 1;

/* 3 */
select *
from public.employees as e
inner join (
    select department_id, max(salary) as max_salary
    from public.employees
    group by department_id
) as d on d.department_id = e.department_id and d.max_salary = e.salary;

Look

DocSportello Jul 15 2024 at 07:17

Больше нравится вариант с оконной функцией, компактно получилось)

/* 1 */
select *
from public.employees
where salary in (
    select max(salary)
    from public.employees
    group by department_id
);

/* 2 */
select *
from (
    select *, dense_rank() over(partition by department_id order by salary) as rank
    from public.employees
) as t
where t.rank = 1;

/* 3 */
select *
from public.employees as e
inner join (
    select department_id, max(salary) as max_salary
    from public.employees
    group by department_id
) as d on d.department_id = e.department_id and d.max_salary = e.salary;

Look

Мигрируем с SQL Server на PostgreSQL двумя способами

DocSportello Mar 27 2024 at 05:31

DataGrip пожалуй лучший инструмент для работы с базами

Look