DEV Community

bikashgosai
bikashgosai

Posted on • Updated 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

pelvid profile image

New To react

Pelvid -

tanujav profile image

Insertion Sort in Java (With Intuition + Dry run + Code)

Alysa -

poetaman profile image

manpage art, man is still alive

poetaman -

ingigauti profile image

Bot posting on twitter using Plang

Ingi -