---
title: "Difference between SQL SELECT UNIQUE and SELECT DISTINCT"
url: https://daily.dev/posts/difference-between-sql-select-unique-and-select-distinct-eexstw7dd
source_url: https://www.sqlshack.com/difference-between-sql-select-unique-and-select-distinct/
type: article
source: "SQL Shack"
published: 2024-01-16T10:29:38.575Z
updated: 2024-01-16T10:29:37.489Z
tags: ["database", "sql", "oracle"]
reading_time: 7
upvotes: 28
comments: 2
language: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Difference between SQL SELECT UNIQUE and SELECT DISTINCT

**[SQL Shack](https://daily.dev/sources/sqlshack)** · 7 min read · 28 upvotes · 2 comments

## Summary

Learn about the difference between SQL SELECT UNIQUE and SELECT DISTINCT, the use of UNIQUE constraint, and the syntax for executing these statements in Oracle. Both statements are used to fetch unique values from a column that may have duplicate values.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://www.sqlshack.com/difference-between-sql-select-unique-and-select-distinct/>

## Community discussion

Top comments from developers on daily.dev.

**@callmebrian** · 3 upvotes

> TL, DON'T WANT TO READ: They both the same. Just different on syntax. Writer wrote too long

## Similar posts on daily.dev

- [Don’t just attend KubeCon \+ CloudNativeCon, Merge Forward your experience\!](https://daily.dev/posts/don-t-just-attend-kubecon-cloudnativecon-merge-forward-your-experience--l0rpp73x8) · CNCF · 0 upvotes · 0 comments
- [Announcing H2 2026 KCDs](https://daily.dev/posts/announcing-h2-2026-kcds-m96goajm1) · CNCF · 1 upvotes · 0 comments
- [Two months of Open Community Groups](https://daily.dev/posts/two-months-of-open-community-groups-asf52zhbs) · CNCF · 0 upvotes · 0 comments

---

Tags: [#database](https://daily.dev/tags/database), [#sql](https://daily.dev/tags/sql), [#oracle](https://daily.dev/tags/oracle)

[View this post on daily.dev](https://daily.dev/posts/difference-between-sql-select-unique-and-select-distinct-eexstw7dd)