Duplicate Rows Across All Columns
Medium
Advanced Queries
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.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.