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 is the difference between class and an object?
What is difference between InnoDB and MyISAM?
What is difference between xhr.status and xhr.readyState?