counting the no of times a value occured and sorting the fields in a table

[neenaprasad]

In the table the fields are id, first_name, last_name, introduced_by (which is integer value i.e., 1,2,3,4,5...). This number occurs more than once in the table. I have to count the number of times each number occurs(that means a single value for eg: 2) and sort it according to the count and display the output in ascending order..Can u help me?

[idsanjeev]

In the table the fields are id, first_name, last_name, introduced_by (which is integer value i.e., 1,2,3,4,5...). This number occurs more than once in the table. I have to count the number of times each number occurs(that means a single value for eg: 2) and sort it according to the count and display the output in ascending order..Can u help me?

Hi Neenaprasad
If I am not wrong then You wants to count duplicate recrds from table
so the select statement is change it according to your need

SELECT YourColumn, COUNT(*) TotalCount
FROM YourTable
GROUP BY YourColumn
HAVING COUNT(*) > 1
ORDER BY COUNT(*) ASC