|
View previous topic :: View next topic
|
| Author |
Message |
ismail1816
New User
Joined: 28 Nov 2008
Posts: 3
Location: bangalore
|
|
|
|
Hi All,
I have 10 phone numbers each phone will be come atleast ones some phones will be come more then ones also I want to know which number how many times repeated. Given below I am showing my expected result. According that result any body can you sagest me how to write the db2 query...
Telnumb
------------- ---
9652146584 2
9362548712 1
9658745222 7 |
|
| Back to top |
|
 |
Prasanthhere
Active User
Joined: 03 Aug 2005
Posts: 306
|
|
|
|
How about this query
SELECT Phonenumber,COUNT(Phonenumber) AS COUNT FROM
tablename
GROUP BY Phonenumber ; |
|
| Back to top |
|
|
ismail1816
New User
Joined: 28 Nov 2008
Posts: 3
Location: bangalore
|
|
|
|
Hi Prasanth,
It's working properly thanks given this query |
|
| Back to top |
|
|
|
|
