Fetch duplicate emails and second max value
Filed under Practo
The question
Write an SQL query to fetch duplicate emails from a table and find the second maximum value from a column.
No write-up yet. Related questions below have one.
Related Practo questions
Collected from public candidate posts and coding forums. Updated Nov 2026.