DEV Community

bikashgosai
bikashgosai

Posted on • Edited on

MS-SQL, LIST FROM TABLE WHOSE VALUE IS REPEATED MORE THAN ONCE.

#mssql #sql 
SELECT 
NAME, EMAIL, COUNT(*) 
FROM 
USERS 
GROUP BY
 NAME, EMAIL
HAVING COUNT(*) > 1
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Read next

nareshnishad profile image

PostgreSQL Connection Pooling vs No Pooling: Benchmark Analysis

Naresh Nishad -

roxana_haidiner profile image

Top 8 Free Database Design Tools for 2025

Roxana Maria Haidiner -

pentest_testing_corp profile image

Preventing SQL Injection (SQLi) in React.js Apps

Pentest Testing Corp -

adammetis profile image

Everyone Uses Postgres… But Why?

Adam Furmanek -