tag:blogger.com,1999:blog-341905815790009237.post7435806946144658323..comments2024-03-21T01:46:55.974-07:00Comments on O Oracle ludzkim głosem: Kurs Oracle SQL . Grupowanieandrewhttp://www.blogger.com/profile/10069507480509251586noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-341905815790009237.post-37309650892754191982015-11-20T04:05:42.292-08:002015-11-20T04:05:42.292-08:00Moim zdaniem w zadaniu 6 do klauzuli where powinno...Moim zdaniem w zadaniu 6 do klauzuli where powinno zostać dodane <br /> and last_name not like 'E%'<br />bez niego pozostają nazwiska rozpoczynające się na EinMyOpinionhttps://www.blogger.com/profile/14112695010139458531noreply@blogger.comtag:blogger.com,1999:blog-341905815790009237.post-12940828574285433582014-03-18T07:10:29.886-07:002014-03-18T07:10:29.886-07:00W zadaniu 7 wprowadziłbym małą poprawkę, która sp...W zadaniu 7 wprowadziłbym małą poprawkę, która spowoduje ze nie bedzie podsumowania zbiorowego bo nie bylo w zadaniu o nim mowy. A zatem zwiniemy tylko kolumne manager_id.<br /><br />Select department_id, manager_id, avg(salary) from employees group by department_id, rollup(manager_id) order by 1, 2;thawkuhttps://www.blogger.com/profile/13564262199088171501noreply@blogger.comtag:blogger.com,1999:blog-341905815790009237.post-53430480109495317672014-02-05T14:35:48.201-08:002014-02-05T14:35:48.201-08:00Ogólnie się z Tobą zgadzam, jednakże mam nieco inn...Ogólnie się z Tobą zgadzam, jednakże mam nieco inne propozycje:<br /><br />1. Select department_id, max(salary) najwyzsz_pensja from employees group by department_id order by 1<br />2. Select manager_id, max(salary) najwyzsza_pensja from employees group by manager_id order by 1<br />3. Select department_id, max(salary) najwyzsza_pensja from employees group by department_id order by najwyzsza_pensja<br />4. Select department_id, avg(distinct salary) sred_placa_bez_powt from employees group by department_id order by 1<br />5. Select department_id, max(salary) najwyzsza_pensja from employees group by department_id having department_id in(50, 60, 80) order by 1<br />6. Select department_id, min(salary) pensja_minimalna from employees where last_name not like '%e%' group by department_id order by 1<br />7. Select department_id, manager_id, avg(salary) from employees group by rollup (department_id, manager_id) order by 1, 2<br />8. Select department_id, manager_id, avg(salary) from employees group by cube (department_id, manager_id) order by 1, 2<br />9. Select department_id, manager_id, avg(salary) from employees group by rollup (department_id, manager_id) having department_id in (50, 80, 60) order by 1, 2<br />10. Select department_id, manager_id, avg(salary) from employees group by cube (department_id, manager_id) having department_id in (50, 80, 60) order by 1, 2Relatywistahttps://www.blogger.com/profile/04087529862315612630noreply@blogger.comtag:blogger.com,1999:blog-341905815790009237.post-11242727148102257912012-10-13T06:14:19.331-07:002012-10-13T06:14:19.331-07:00Fajnie się to czyta. Mam jednak pytania co do roll...Fajnie się to czyta. Mam jednak pytania co do rollup:<br />1. Pierwszy przykład: w tekście"... grupowania z bez użycia" napisałeś "z i "bez" - co chyba się wyklucza. W zapytaniu nie odnajduję rollup.<br />2. W drugim przykładzie jest rollup, a nie ma podsum - czy jest ono potrzebne?.<br />3. Proponuję bardziej szczegółowo skomentować przykłady oraz opisać na czym polega różnica objęciem rollup jednej lub obu kolumn.<br />4. W aktualnym wydaniu OracleXE struktura i zawartość przykładowej bazy danych jest inna - może warto by odświeżyć przykłady.Adamhttps://www.blogger.com/profile/08958592285000999693noreply@blogger.comtag:blogger.com,1999:blog-341905815790009237.post-88583293480496599732012-10-13T06:10:12.158-07:002012-10-13T06:10:12.158-07:00Ten komentarz został usunięty przez autora.Adamhttps://www.blogger.com/profile/08958592285000999693noreply@blogger.comtag:blogger.com,1999:blog-341905815790009237.post-65955939848478626952012-05-09T13:25:01.351-07:002012-05-09T13:25:01.351-07:00Moje rozwiązania:
ad1: SQL> select department_...Moje rozwiązania:<br /><br />ad1: SQL> select department_id, max(salary) from employees group by department_id order by 1;<br /><br />ad2: SQL> select manager_id, max(salary) from employees group by manager_id order by 1;<br /><br />ad3: SQL> select department_id, max(salary) from employees where department_id is not null group by department_id order by 2;<br /><br />ad4: SQL> select distinct round(avg(salary)), department_id from employees where department_id is not null group by department_id order by 1;<br /><br />ad5: SQL> select department_id, max(salary) from employees where department_id in (50,80,60) group by department_id;<br /><br />ad6: SQL> select department_id, min(salary) from employees where last_name not like '%E%' and last_name not like '%e%' and department_id is not null group by department_id order by 2;<br /><br />ad7: SQL> select avg(salary), manager_id, department_id from employees where department_id is not null group by rollup(department_id, manager_id);<br /><br />ad8: SQL> select avg(salary), manager_id, department_id from employees where department_id is not null and manager_id is not null group by cube(department_id, manager_id);<br /><br />ad9: SQL> select avg(salary), manager_id, department_id from employees where department_id in (50,80,60) group by rollup(department_id, manager_id);<br /><br />ad10: SQL> select avg(salary), manager_id, department_id from employees where department_id in (50,80,60) group by cube(department_id, manager_id);Kowalski Piotrhttps://www.blogger.com/profile/02502934861157191054noreply@blogger.comtag:blogger.com,1999:blog-341905815790009237.post-61577602726117998872011-09-08T17:48:30.545-07:002011-09-08T17:48:30.545-07:00Można prosić o jakiś klucz?Można prosić o jakiś klucz?Marcin2x4https://www.blogger.com/profile/05341647506694785115noreply@blogger.com