Categories: MySQL

Use DISTINCT to eliminate duplicate rows

Share

In a table there may be data available i.e. duplicate. Each time you querying and get all the duplicate data.

Use DISTINCT to avoid it.

Suppose in a coountry table there are two same country name the using DISTINCT you will get the only one name for each country.

SELECT DISTINCT country_name FROM table_country;

Recent Posts

India General Elections 2024: A Historic Event

The 2024 Indian General Elections are taking place now, with every individual in the country…

3 hours ago

Unveiling the Ultimate Car Cleaning Kit: Your Road to a Pristine Ride

Introduction: In order to stay clean, car care all in the world is not only…

10 hours ago

Oppo vs Vivo: The Race to be the Number One Smartphone in India

Oppo and Vivo are two smartphone makers in India that manufacture quality mobile phones at…

23 hours ago

10 Reasons Why Technology is Good for Education

Educational technology has been very helpful in the era of ever-advancing technology. It opens millions…

1 day ago

Chat GPT Login: Step-by-Step Guide for Beginners

Have you ever thought of a world where asking the Internet for information feels like…

1 day ago

The Sharp-Looking Guy: 5 Essential Tips for Men to Become Sharp

We've gotten so used to seeing men streetwear joggers, ripped jeans, and sleeveless shirts. Hair…

3 days ago