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

T

twittoponchik2022-01-07 12:30:00

R

Romi2021-03-22 23:42:55

P

Pavel2014-05-18 14:34:20

F

fara_ib2019-09-21 18:21:15

G

gargamel12021-04-18 00:54:18

Didn't find what you were looking for?