DB2 QUERY

richa.setia · New User Joined: 23 Mar 2005 Posts: 10 Location: Noida

Hi,

I am learning DB2 and have come across a query.

I have a emp table with emp id, emp name and emp location.
Here emp location is not a unique value.

Please tell me a query on how do u get the total count of how many time each location exists?

Distinct will just give the different location but i also want the no of times same location is repeated.

Thanks,
Richa

chani823 · New User Joined: 30 Mar 2005 Posts: 5

Hi Richa

required query is

vasanthanc · New User Joined: 01 Apr 2005 Posts: 58

U need not to use distinct. Following query will do

Select location, count(location) as tot_count from emp group by loction