How

[JustWorking]

How to select duplicate names in SQL?

[Jorgen Andersson]

SELECT *
FROM Table
HAVING Count(name) > 1

To get a better answer you'll need to specify your question better.

My postings are a natural product. The slight variations in spelling and grammar enhance their individual character and beauty and are in no way to be considered flaws or defects.

[JustWorking]

Can we use HAVING without GROUPING

[Jorgen Andersson]

No, Sorry about that.

My postings are a natural product. The slight variations in spelling and grammar enhance their individual character and beauty and are in no way to be considered flaws or defects.