Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to calculate the total of a varchar column?
Hi,
... a bit shorter version
SELECT COUNT(gender), gender, NVL(gender, 'ALL') FROM test_gender GROUP BY GROUPING SETS(gender,0)
Regards
Adrian
Received on Mon Feb 13 2006 - 12:20:17 CST