Member Avatar for locsin

Greetings!

Anybody have idea how the determine the same numbers in 100 records. For example there are 100 inputted numbers in the database file. These numbers, some numbers have the same value.

Anyone know to determine these numbers and display like this.

input
100 numbers inputted in the database file


sample output.

Number ...................... total number with the same value
34 ............................... 20
2 .............................. 15
78 .............................. 36
5 .............................. 9
17 .............................. 11
56 .............................. 8
3 .............................. 1

the numbers from the left is the inputted numbers in the database file. and the numbers from the right is the total of how many times these numbers were inputted or total numbers with the same value.

Thanks in advance.

  • 2 Contributors
  • 1 Reply
  • 127 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

What about simply using a COUNT on the database table !!!

something like the following

select num,count(num) from table_name group by num
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.