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

adammetis profile image

Debugging Low Cache Hit Ratio

Adam Furmanek -

christianpaez profile image

The Ultimate SQL JOIN Cheat Sheet

Christian Paez -

gadekar_sachin profile image

# 🚀 SQL Automation Testing: A Beginner's Guide

Sachin Gadekar -

mrcaption49 profile image

SQL Query Logical Order

Pranav Bakare -