Wipro interview question

What are SQL Queries required to display duplicate and distinct Data?