Database

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