What is the difference between DISTINCT and GROUP BY?
What is the difference between DISTINCT and GROUP BY?
1 answer
by
julio.mcglynn ,
3 years ago
DISTINCT can return NULL values because it considers NULL as a value and selects one NULL from many, however, GROUP BY does not consider NULL values as a record. GROUP BY sorts the records where DISTINCT does not.
15
Related Threads:
What is the use of the DISTINCT phrase in MySQL?
Describe your experience with Active Directory, Group Policy, and other common Windows-based tools.
Can you share your experience in conducting workshops or group counseling sessions for university students?
What Are the Key Features Of Codeigniter 4 in 2025?
What Are the Best Practices for Optimizing Performance in React.js Applications
What is the difference between class and an object?