To find count of repeated ids and different ids using Oracle query we created one Employee table. In that table there are four column id, name, designation and department. from group by function we grouping the designation date and count the id.
select * from Employee;
|
ID |
NAME |
DESIGNATION |
DEPARTMENT |
|
1 |
Aman |
Software Developer |
Software Development |
|
2 |
Vijay |
Team Lead |
Software Development |
|
3 |
Pankaj |
Manager |
Human Resources |
|
4 |
Ravi |
VP |
Human Resources |
|
5 |
Kamal |
VP |
Software Development |
select count(ID),designation from Employee group by(designation);
|
COUNT(ID) |
DESIGNATION |
|
1 |
Team Lead |
|
1 |
Manager |
|
1 |
Software Developer |
|
2 |
VP |