Member Avatar for rajeesh_rsn

Hi friends,

My table structure as like this

name | id | Roles
-------------------------------
name1 | 1012 | Cleaning, Cooking
name2 | 1013 | Cooking

---------------------------------------------

I want to select all the repeating names ie,
Want to display the name which coming more than 1 times in database.

Please help me
Thanks in advance
Rajeesh

  • 2 Contributors
  • 1 Reply
  • 71 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by mwasif
Member Avatar for mwasif

Are you looking for this?

SELECT name FROM table
GROUP BY name
HAVING COUNT(*)>1
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.