Getting count of each row in oracle sql

Question

Consider below table:

EmpId  EmpType ExpUniId
1       A        234
1       B        453
2       A        454

I want to write a sql query such that I get following data

EmpId  EmpType ExpUniId   Count
1       A        234       2
1       B        453       2
2       A        454       1

Count implies number of rows corresponding to each Emp Id

I am using Oracle Sql.

Thanks

Gordon Linoff · Accepted Answer · 2014-11-17 15:20:25Z

5

You are looking for the analytic version of count():

select t.*,
       count(*) over (partition by EmpId) as Count
from table t;

answered Nov 17, 2014 at 15:20

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1