# \[Feature Request\]: Add "Deduplicate" option alongside group and sort

**URL:** <https://community.nocodb.com/t/feature-request-add-deduplicate-option-alongside-group-and-sort/2097>\
**Category:** Uncategorized\
**Created:** [October 2, 2025, 5:17pm UTC](https://community.nocodb.com/t/feature-request-add-deduplicate-option-alongside-group-and-sort/2097 "2025-10-02T17:17:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![johnbalis](https://avatars.discourse-cdn.com/v4/letter/j/c68b51/32.png) [@johnbalis](https://community.nocodb.com/u/johnbalis)\
**Post date:** [October 2, 2025, 5:17pm UTC](https://community.nocodb.com/t/feature-request-add-deduplicate-option-alongside-group-and-sort/2097/1 "2025-10-02T17:17:25Z")

</div>

![image](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/d5ab26e30eac3e7227dcc6b63f7605582b850921.jpeg)

Above is an impressionistic sketch from Gemini.

The idea is we want to be able to de-duplicate records that share a column value in a view, while keeping the first n according to some ordering. Ideally for each deduplication, you should be able to specify, the target column to depuplicate on, n, and the ordering (which has the same params as a sort).

This is easy to implement, and will unlock a lot of value for us by preventing us from having to create explicit “Most recent result” columns and manually relabel existing results, if we want a view of our most recent results for each serial number.

---

<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:** [October 2, 2025, 5:40pm UTC](https://community.nocodb.com/t/feature-request-add-deduplicate-option-alongside-group-and-sort/2097/2 "2025-10-02T17:40:25Z")

</div>

Thank you for coming up with the design with Gemini 🙂

I believe this would be better to be done using an extension. Will make this part of our roadmap.