Srinimf

SQL: GROUP BY Preferable than DISTINCT Why

·

,
Tags: ,
SQL: GROUP BY Preferable than DISTINCT Why

We should not use DISTINCT in SQL query, it takes more up.

Select distict ename,enum

from emp

where ename=’krishna’

and enum=1000

The alternative way is:

Select ename,enum

from emp

where ename=’krishna’

and enum=1000

group by ename,enum

Srini's avatar

Srini

Data Engineer with deep AI and Generative AI expertise, crafting high-performance data pipelines in PySpark, Databricks, and SQL. Skilled in Python, AWS, and Linux—building scalable, cloud-native solutions for smart applications.

Latest Posts

Jooble.org jobs