What is the difference between DISTINCT and GROUP BY?
What is the difference between DISTINCT and GROUP BY?
1 answer
by
julio.mcglynn
,
3 months 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.
Related Threads:
What is the use of the DISTINCT phrase in MySQL?
What is difference between InnoDB and MyISAM?
What is difference between xhr.status and xhr.readyState?
What is the basic difference between overloading and overriding?
What is the difference between class and an object?
What are differences between Trigger and Stored Procedure?