Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Duplicate Rows Across All Columns

Return the rows that appear more than once across all columns (name, city, age) with the number of occurrences.

Table schema

People(name VARCHAR(50), city VARCHAR(50), age INT)

Sample data

name | city | age
Amy | Pune | 20
Amy | Pune | 20
Ben | Delhi | 25

Discussion

No discussions yet.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.