# Select Distinct?

**URL:** <https://community.nocodb.com/t/select-distinct/719>\
**Category:** Grid-View\
**Created:** [November 15, 2022, 4:18pm UTC](https://community.nocodb.com/t/select-distinct/719 "2022-11-15T16:18:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mhickok](https://avatars.discourse-cdn.com/v4/letter/m/76d3ee/32.png) [@mhickok](https://community.nocodb.com/u/mhickok)\
**Post date:** [November 15, 2022, 4:18pm UTC](https://community.nocodb.com/t/select-distinct/719/1 "2022-11-15T16:18:20Z")

</div>

Hey all, I am brand new to this product and mostly new to DBs in general. One of the things I regularly do when interacting with a DB is do a SELECT DISTINCT, as I want to see only the unique values for a column. I cannot figure out how to do this in NocoDB – is this possible?

Thanks!

---

<div class="post-metadata">

**Author:** ![Navi](https://avatars.discourse-cdn.com/v4/letter/n/3be4f8/32.png) [@Navi](https://community.nocodb.com/u/Navi)\
**Post date:** [November 15, 2022, 5:08pm UTC](https://community.nocodb.com/t/select-distinct/719/2 "2022-11-15T17:08:20Z")

</div>

If you are connecting external database - you can create a SQL view for it. And do a [meta sync](https://docs.nocodb.com/setup-and-usages/sync-schema). And we do idenityf that as a view (read only) - that should do it for your usecase.