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

mrcaption49 profile image

RANK,ROW_NUMBER and DENSE_RANK

Pranav Bakare -

vuelancer profile image

Podman - Create A FHIR-Server & SQL Server

Vuelancer -

wilsonjuma254 profile image

Data Analyst Checklist

Wilson Juma -

mrcaption49 profile image

Interval Partitioning in Oracle SQL

Pranav Bakare -