Eliminate duplicate records in SQL

This question was asked in

Walmart Senior Software Engineer Interview Experience

The interview process at Walmart consisted of five comprehensive technical rounds covering a broad range of topics. Across the rounds, the candidate was evaluated on Core Java & Concurrency, Spring Boot internal mechanics, Microservices architecture and DevOps practices, SQL queries and indexing, and Low-Level System Design (LLD). Overall, the process was thorough with a medium-to-hard difficulty level, heavily focusing on deep technical understanding, concurrency, and SOLID principles.