What is the difference between DISTINCT and GROUP BY?
Member
horace
What is the difference between DISTINCT and GROUP BY?
1 answer
by
julio.mcglynn ,
8 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.
15
Related Threads:
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 is the use of the DISTINCT phrase in MySQL?
What are differences between Trigger and Stored Procedure?