Tag:Oracle group function

  • The basic usage of rollup of Oracle grouping function


    Rollup function This blog gives a brief introduction to the usage of rollup in Oracle group function. Rollup function is commonly used in group statistics and is also a kind of Oracle analysis function Environmental preparation create table dept as select * from scott.dept; create table emp as select * from scott.emp; Business scenario: calculate […]