WIDTH_BUCKET Function

[debasisdas]

WIDTH_BUCKET:-
===============
THIS FUNCTION GROUPS ROWS OF THE RESULT SET INTO BUCKETS,BUT IT ATTEMPTS TO CREATE EQUIWIDTH BUCKETS.THIS FUNCTION CAN WORK ON NUMERIC OR DATE DATA TYPE,AND TAKES 4 PARAMETERS.
a)EXPRESSION THAT GENERATE THE BUCKETS.
b)THE VALUE USED AS THE START OF THE RANGE OF BUCKET NO 1.
c)THE VALUE USED AS THE END OF THE RANGE OF BUCKET NO N.
d)THE NUMBER OF BUCKETS TO CREATE(N).

Sample Ex#1
===============

SELECT DEPTNO,EMPNO,SUM(SAL) SALARY,WIDTH_BUCKET(SUM(SAL),1,3000,3)SAL_BUCKET
FROM EMP
GROUP BY DEPTNO,EMPNO 
ORDER BY SAL_BUCKET;

Sample Ex#2
===============

SELECT DEPTNO,EMPNO,SUM(SAL) SALARY,WIDTH_BUCKET(SUM(SAL),1000,6000,3)
SAL_BUCKET FROM EMP
GROUP BY DEPTNO,EMPNO 
ORDER BY SAL_BUCKET;