Create table PersonA(Tbn number primary key, name varchar2(20), otd number, sal number);
--Табельный номер , имя, отдел , зарплата
Insert into PersonA(Tbn,name,otd,sal) values(1, 'Аня',10,9000);
Insert into PersonA(Tbn,name,otd,sal) values(2, 'Саша',10,5500);
Insert into PersonA(Tbn,name,otd,sal) values(3, 'Таня',10,7000);
Insert into PersonA(Tbn,name,otd,sal) values(4, 'Ваня',20,2300);
Insert into PersonA(Tbn,name,otd,sal) values(5, 'Олег',20,4300);
Insert into PersonA(Tbn,name,otd,sal) values(6, 'Коля',20,3900);
Insert into PersonA(Tbn,name,otd,sal) values(7, 'Таня',30,7000);
Insert into PersonA(Tbn,name,otd,sal) values(8, 'Макс',30,9000);
Insert into PersonA(Tbn,name,otd,sal) values(9, 'Таня',30,8500);
Insert into PersonA(Tbn,name,otd,sal) values(10,'Макс',30,9900);
Insert into PersonA(Tbn,name,otd,sal) values(11,'Олег',30,9900);
Insert into PersonA(Tbn,name,otd,sal) values(12,'Макс',30,9900);
Insert into PersonA(Tbn,name,otd,sal) values(13,'Макс',30,9900);
Insert into PersonA(Tbn,name,otd,sal) values(14,'Макс',30,9900);
Insert into PersonA(Tbn,name,otd,sal) values(15,'Макс',30,9900);
Insert into PersonA(Tbn,name,otd,sal) values(16,'Макс',30,7000);
Insert into PersonA(Tbn,name,otd,sal) values(17,'Таня',30,3500);
select name, otd, sal,
MIN(sal) OVER (partition by otd) min_sal,
MAX(sal) OVER (partition by otd) max_sal,
MIN(sal) KEEP (DENSE_RANK FIRST ORDER BY sal) OVER (partition by otd) min_keep_sal,
MAX(sal) KEEP (DENSE_RANK LAST ORDER BY sal) OVER (partition by otd) max_keep_sal,
FIRST_VALUE(sal) OVER (partition by otd order by sal range between unbounded preceding and unbounded following) first_val_sal,
LAST_VALUE(sal) OVER (partition by otd order by sal range between unbounded preceding and unbounded following) last_val_sal
from personA;
Q3JlYXRlIHRhYmxlIFBlcnNvbkEoVGJuIG51bWJlciBwcmltYXJ5IGtleSwgbmFtZSB2YXJjaGFyMigyMCksIG90ZCBudW1iZXIsIHNhbCBudW1iZXIpOyAKLS3QotCw0LHQtdC70YzQvdGL0Lkg0L3QvtC80LXRgCAsINC40LzRjywg0L7RgtC00LXQuyAsINC30LDRgNC/0LvQsNGC0LAKCkluc2VydCBpbnRvIFBlcnNvbkEoVGJuLG5hbWUsb3RkLHNhbCkgdmFsdWVzKDEsICfQkNC90Y8nLDEwLDkwMDApOwpJbnNlcnQgaW50byBQZXJzb25BKFRibixuYW1lLG90ZCxzYWwpIHZhbHVlcygyLCAn0KHQsNGI0LAnLDEwLDU1MDApOwpJbnNlcnQgaW50byBQZXJzb25BKFRibixuYW1lLG90ZCxzYWwpIHZhbHVlcygzLCAn0KLQsNC90Y8nLDEwLDcwMDApOwpJbnNlcnQgaW50byBQZXJzb25BKFRibixuYW1lLG90ZCxzYWwpIHZhbHVlcyg0LCAn0JLQsNC90Y8nLDIwLDIzMDApOwpJbnNlcnQgaW50byBQZXJzb25BKFRibixuYW1lLG90ZCxzYWwpIHZhbHVlcyg1LCAn0J7Qu9C10LMnLDIwLDQzMDApOwpJbnNlcnQgaW50byBQZXJzb25BKFRibixuYW1lLG90ZCxzYWwpIHZhbHVlcyg2LCAn0JrQvtC70Y8nLDIwLDM5MDApOwpJbnNlcnQgaW50byBQZXJzb25BKFRibixuYW1lLG90ZCxzYWwpIHZhbHVlcyg3LCAn0KLQsNC90Y8nLDMwLDcwMDApOwpJbnNlcnQgaW50byBQZXJzb25BKFRibixuYW1lLG90ZCxzYWwpIHZhbHVlcyg4LCAn0JzQsNC60YEnLDMwLDkwMDApOwpJbnNlcnQgaW50byBQZXJzb25BKFRibixuYW1lLG90ZCxzYWwpIHZhbHVlcyg5LCAn0KLQsNC90Y8nLDMwLDg1MDApOwpJbnNlcnQgaW50byBQZXJzb25BKFRibixuYW1lLG90ZCxzYWwpIHZhbHVlcygxMCwn0JzQsNC60YEnLDMwLDk5MDApOwpJbnNlcnQgaW50byBQZXJzb25BKFRibixuYW1lLG90ZCxzYWwpIHZhbHVlcygxMSwn0J7Qu9C10LMnLDMwLDk5MDApOwpJbnNlcnQgaW50byBQZXJzb25BKFRibixuYW1lLG90ZCxzYWwpIHZhbHVlcygxMiwn0JzQsNC60YEnLDMwLDk5MDApOwpJbnNlcnQgaW50byBQZXJzb25BKFRibixuYW1lLG90ZCxzYWwpIHZhbHVlcygxMywn0JzQsNC60YEnLDMwLDk5MDApOwpJbnNlcnQgaW50byBQZXJzb25BKFRibixuYW1lLG90ZCxzYWwpIHZhbHVlcygxNCwn0JzQsNC60YEnLDMwLDk5MDApOwpJbnNlcnQgaW50byBQZXJzb25BKFRibixuYW1lLG90ZCxzYWwpIHZhbHVlcygxNSwn0JzQsNC60YEnLDMwLDk5MDApOwpJbnNlcnQgaW50byBQZXJzb25BKFRibixuYW1lLG90ZCxzYWwpIHZhbHVlcygxNiwn0JzQsNC60YEnLDMwLDcwMDApOwpJbnNlcnQgaW50byBQZXJzb25BKFRibixuYW1lLG90ZCxzYWwpIHZhbHVlcygxNywn0KLQsNC90Y8nLDMwLDM1MDApOwoKc2VsZWN0IG5hbWUsIG90ZCwgc2FsLCAKTUlOKHNhbCkgT1ZFUiAocGFydGl0aW9uIGJ5IG90ZCkgbWluX3NhbCwKTUFYKHNhbCkgT1ZFUiAocGFydGl0aW9uIGJ5IG90ZCkgbWF4X3NhbCwKTUlOKHNhbCkgS0VFUCAoREVOU0VfUkFOSyBGSVJTVCBPUkRFUiBCWSBzYWwpIE9WRVIgKHBhcnRpdGlvbiBieSBvdGQpIG1pbl9rZWVwX3NhbCwKTUFYKHNhbCkgS0VFUCAoREVOU0VfUkFOSyBMQVNUIE9SREVSIEJZIHNhbCkgT1ZFUiAocGFydGl0aW9uIGJ5IG90ZCkgbWF4X2tlZXBfc2FsLApGSVJTVF9WQUxVRShzYWwpIE9WRVIgKHBhcnRpdGlvbiBieSBvdGQgb3JkZXIgYnkgc2FsIHJhbmdlIGJldHdlZW4gdW5ib3VuZGVkIHByZWNlZGluZyBhbmQgdW5ib3VuZGVkIGZvbGxvd2luZykgZmlyc3RfdmFsX3NhbCwKTEFTVF9WQUxVRShzYWwpIE9WRVIgKHBhcnRpdGlvbiBieSBvdGQgb3JkZXIgYnkgc2FsIHJhbmdlIGJldHdlZW4gdW5ib3VuZGVkIHByZWNlZGluZyBhbmQgdW5ib3VuZGVkIGZvbGxvd2luZykgbGFzdF92YWxfc2FsCmZyb20gcGVyc29uQTs=