Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Count Duplicated Values in a Column
How To Count Duplicated Values in a Column? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY
✍: FYIcenter.com
If you have a column with duplicated values, and you want to know what are those duplicated values are and how many duplicates are there for each of those values, you can use the GROUP BY ... HAVING clause as shown in the following example. It returns how many duplicated first names in the fyi_team table:
mysql> SELECT first_name, COUNT(*) FROM fyi_team GROUP BY first_name HAVING COUNT(*) > 1; +------------+----------+ | first_name | COUNT(*) | +------------+----------+ | John | 6 | +------------+----------+ 1 row in set (0.01 sec)
2007-05-11, 4892👍, 0💬
Popular Posts:
.NET INTERVIEW QUESTIONS - How can you avoid deadlock in threading? A good and careful planning can ...
How can we connect to Microsoft Access , Foxpro , Oracle etc ? Microsoft provides System.Data.OleDb ...
How To Assign Debug Privileges to a User? - Oracle DBA FAQ - Introduction to Oracle SQL Developer In...
How can I check for HTML errors? HTML validators check HTML documents against a formal definition of...
What is a measure in OLAP ? Measures are the key performance indicator that you want to evaluate. To...