Hi thanks got it..

select

empno,

ename,

deptno,

sal,

(select count(sal)+1 from emp b where b.deptno=a.deptno...

Hi Thanks,

I need the result without using any predefined functions like row_number(),rank(),dense_rank(),ntile()..

thanks shiv..