Ask Question Sign In Sign Up
Home
Sign In
Sign Up
  • Home
  • >
  • Technology
  • >
  • What is the difference between DISTINCT and GROUP BY?
Arts Real Estate Legal Human Resources Fitness & Wellness Retail Building & Construction Sales & Business Development Education Media Healthcare Technology Marketing Common Job Roles
Category
Arts
Real Estate
Legal
Human Resources
Fitness & Wellness
Retail
Building & Construction
Sales & Business Development
Education
Media
Healthcare
Technology
Marketing
Common Job Roles

What is the difference between DISTINCT and GROUP BY?

Member

horace

by horace , in category: Technology , a year ago

What is the difference between DISTINCT and GROUP BY?

0 | 0
0
Facebook Twitter LinkedIn Telegram Whatsapp

1 answer


Member

julio.mcglynn

by julio.mcglynn , a year 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.

0 | 0
0
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?

About us

  • Contact us
© 2023 Copyright: theinternettoday.net

This Site is Created By mywebforum.com

Get Your Own Questions & Answers platform