GROUP BY might be distinctly better than DISTINCT
One of the cool things with materialised* views in Oracle is their ability to be kept in sync with the
Tag: group by
LISTAGG hits prime time
It’s a simple requirement. We want to transform this: SQL> select deptno, ename 2 from emp 3 order by 1,2;
