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

akhil_mittal profile image

Designing a Production-Grade Database for High-Traffic Applications on AWS RDS MySQL

akhil mittal -

nirmal_s_1505 profile image

LIBRARY MANAGEMENT SYSTEM USING JAVA AND SQL

Nirmal S -

esproc_spl profile image

SQL: Recursive calculation of tree like hierarchical structure #eg83

Judy -

yiran_jing_d932aa8bc72a83 profile image

Database Tools 🛢️🔧 in 2024: A Year in Review 🗓️

Yiran Jing -