Tanlang * Jadval1 dan t1 sifatida Chapga JOIN qilinadigan jadval2 sifatida t2 ON t1.date_start > t2.date_start --DML Agar mavjud bo'lmasa Employee jadvalini yaratish (id int, salary int, departmentId int); Employee ga qo'shish (id,salary,departmentId) QIYMATLAR bilan (1, 70000, 1),(2, 94000, 1),(3, 85000, 1),(4, 80000, 2),(5, 60000, 2),(6, 62000, 3),(7, 90000, 3),(8, 94000, 3),(9, 94000, 3); cte bilan( tanlang *, rank() over(partition by departmentId order by salary desc) sifatida max_salary Employee dan ) tanlang * from cte qayerda max_salary = 1