Need to get count of repeated values in a table

aryanpa1 · New User Joined: 26 May 2007 Posts: 45 Location: Chennai

Hi Team ,

I have a DB2 table called sudent_info. I need to get the count of people with the same name.

Example : The table containing data as below

STU_NO STU_NAME
1 ---------- A
2 ---------- B
3 ---------- A
4 ---------- C
5 ---------- B
6 ---------- A

I need the result like

Name Count
A ------ 3
B ------ 2
C ------ 1

Can you please suggest.

Suresh Ponnusamy · Posted: Sat Sep 13, 2008 1:39 am

Hi

Please try this

SELECT STU_NAME ,COUNT(STU_NAME)
FROM
STUDENT_INFO
GROUP BY STU_NAME

aryanpa1 · New User Joined: 26 May 2007 Posts: 45 Location: Chennai

Thank you very much Suresh it worked.

Suresh Ponnusamy · Posted: Sat Sep 13, 2008 7:10 am

Hi Pavan

You are welcome