Ask Question Sign In Sign Up

What is the use of the DISTINCT phrase in MySQL?

Member

by alf.murazik , in category: Technology , 3 years ago

What is the use of the DISTINCT phrase in MySQL?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by rosa , 3 years 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 is VIEW MySQL?
What are aggregate functions in MySQL?
What are Stored Procedures in MySQL?
What are the storage engines used by MySQL?
Which one is the default storage Engine in MySQL?