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

mrcaption49 profile image

Stored procedure in PLSQL

Pranav Bakare -

pawsql profile image

🚀 Boosting TPC-H Q2 Query Performance by 1000x times: PawSQL Optimization Techniques

Tomas@PawSQL -

01kg profile image

Supabase | Seeding data: The Problem (ERROR: SQLSTATE 22021) and Solutions

01kg -

mrcaption49 profile image

Virtual tables in SQL - Views, Materialized View, Global Temporary Table and Inline View

Pranav Bakare -