DEV Community

bikashgosai
bikashgosai

Posted on • Updated on

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

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

Discussion (0)