Ask Question Sign In Sign Up

What is the use of the DISTINCT phrase in MySQL?

Member

alf.murazik

by alf.murazik, in category: Technology , 8 months ago

What is the use of the DISTINCT phrase in MySQL?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by rosa , 8 months ago

@alf.murazik DISTINCT eliminates the duplicate records in the selection and return unique values. We can use it also with aggregate functions like AVG, SUM, MAX, MIN etc.

Related Threads:

What is the difference between DISTINCT and GROUP BY?
What are the storage engines used by MySQL?
Which one is the default storage Engine in MySQL?
What are Stored Procedures in MySQL?
What is VIEW MySQL?
What are aggregate functions in MySQL?