How to write a query to display duplicate values for a table column?

U

ugovin2014-10-20 20:52:19

MySQL

ugovin, 2014-10-20 20:52:19

The table has a field cid of type int.
I don't know if there are duplicate values or if it's unique.
What query can display duplicate values?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Anton, 2014-10-20
@zeromodule

SELECT cid, COUNT(cid)
FROM table
GROUP BY cid
HAVING COUNT(cid) > 1

Similar questions

A

Anton Zolotarev2015-04-20 17:51:12

I

ivanesi2014-05-23 18:39:30

A

Alexander Pankov2016-07-11 11:23:40

M

Marty McFly2018-12-10 19:55:49

G

GhostMath2022-02-09 15:51:25

Didn't find what you were looking for?