Home >> MySql >> Distinct keyword in MySql

Distinct keyword in MySql

The DISTINCT keyword is used to only different(individual) values.

In a table, a column contains many duplicate values and you only want to list the different(individual) values.

Syntax

SELECT DISTINCT column1 FROM tablename

Post Your Comment

Next Questions
Sorting
Between
Having
Union
Union all
Exits
Not Exits
Any
All
Max
Min
Avg
Count
Sum
How to see full query from SHOW PROCESSLIST
How do you display the whole query
How To Find Highest Salary
How To Find Second Highest Salary
How To Find Nth Highest salary
How to calculate number of days between two dates
Calculate days between two dates
How to Find the Number of Days Between Two Dates
How to Find the Number of Days Between Current Date to Specific Date
How much query taking long time to execute
How to Identify Performance Issues with Slow Queries

Copyright ©2022 coderraj.com. All Rights Reserved.