What is the difference between select distinct and group by?

Asked By: Sara Khan

Needhi Jadhau

DIFFERENCE BETWEEN SELECT DISTINCT AND GROUP BY IN SQL DATABASE SERVER

SELECT DISTINCT QUERY

The SELECT DISTINCT is used to filter unique records out of the records that satisfy the query criteria.
For Example - {SELECT DISTINCT Name, Post FROM Employees;} - In this Distinct query (Name and Post) both are the columns name of the Employees table.
DISTINCT will make sure that the same row won’t be returned in the result set twice.
DISTINCT can be implemented with a temporary table where execution rows can be checked.
DISTINCT queries can be implemented using GROUP BY.

GROUP BY CLAUSE

The "GROUP BY" clause is used when you need to group the data and it should be used to apply aggregate operators to each group.
For Example - {SELECT Name, Post FROM Employees GROUP BY Name, Post;} - In this Group By query (Name and Post) both are the columns name of the Employees table.
GROUP BY as the name suggests groups the result by some set of parameters and evaluates the whole result set.
GROUP BY is implemented based on sorting and the same rules apply to it as well in most of the database.
BUT not every GROUP BY query can be translated to DISTINCT.

1 votes

Your Answer

Sarnath Bhagat

What is the difference between details and summary tag?

In HTML details tag and summary tag are used together to achieve the task. The c...

Lili Patel

The Power of 3D: Transforming Ideas into Mesmerizing Visual Realities

3D rendering has the power to transform concepts into mesmerizing visual realiti...

Shubhanker Jha

Which one best and safest hosting provider GoDaddy or HostGator

GoDaddy web hosting provider was founded in 1997 as Jomax Technologies and HostG...

Jasmine

5 Things you should know about Instagram Algorithm to Grow Faster

Instagram is a huge social media app that has taken over the world. The entire w...

Albert Trott

Technologies That Have Helped Mankind Over The Last 10 Years

The past 10 years have seen several groundbreaking changes in technology that......

David Walliams

Sunday Night Routine to Get You Well and Set for the Forthcoming Week

The weekend is over, and it's time to get back to the grind. But before you do, ...

Ushanki

Capgemini interview process, test, salary for fresher & experience, and more

Capgemini interview process is very flexible and they will invite you to join in...

Alen Deory

6 Reasons to Learn Python Programming

Everyone is talking about Python for a good reason. The future of technology wil...

Komolika

KPIT interview process and salary for fresher & experience

KPIT Technology is a global partner to the Automotive Industry and Mobility Ecos...

Reena Pandit

Which CSS property does not influence the box model?

The CSS Box-Model is used to create the design and layout of web pages with the ...

Bevin

Know how you can remove AI Detection using Bypass AI

Bypass AI emerges as a cutting-edge solution in this context, promising to bridg...

Manish

The Best and Cheapest Hosting and Domain Name Providers

Many web hosting companies are currently available worldwide to provide the chea...

Mark R

Social Media Marketing 101

Social media will be right up there in the case that someone enlists the most im...

Adom

How to Generate Random Number in C#?

It is very simple to generate a Random Number in C#, There are is a Random class...

TOP CATEGORIES

What is the difference between select distinct and group by?

Your Answer

Related Topics

Related Topics

Policy & Disclosure

Sitemap

Lifestyle Article