4, 2002 10:43 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Group By - Without using aggregate functions
Check if ROLLUP or CUBE helps.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 23, 20
Title: RE: Group By - Without using aggregate functions
Rollup and cube are sql functions that place subtotals and grand totals into the query (usually shows the other columns as NULL to inidicate a total);
Check the sql reference in the oracle docs for examples of use or the iternet
What's ROLLUP and CUBE is it Oracle's or is it from Java.
TIA!
Aleem
-Original Message-
Sent: Tuesday, September 24, 2002 10:43 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Group By - Without using aggregate functions
Check if ROLLUP or
Check if ROLLUP or CUBE helps.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 23, 2002 01:28 AM
Hi Gurus,
I would like to group by the result of a select statement based on a
particular column.
But I am not using any aggrega
Thanks a lot for your help.
The Java programmers have decided to format the output themselves.
K.
-Original Message-
Sent: Monday, September 23, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L
Karthik,
To me it seems that you do not want any aggregate totals, just a list
gro
USe select deptno, empno from emp
ORDER BY deptno, empno;
-Original Message-
Sent: Monday, September 23, 2002 11:28 AM
To: Multiple recipients of list ORACLE-L
Hi Gurus,
I would like to group by the result of a select statement based on a
particular column.
But I am not usin
Karthik,
To me it seems that you do not want any aggregate totals, just a list
grouping the employees of one department together.
For this if you could try ORDER BY DeptNo, EmpNo, I think it should work,
HTH!
Aleem
-Original Message-
Sent: Monday, September 23, 2002 1:28 PM
To: