# Remove duplicated rows

**URL:** <https://discourse.julialang.org/t/remove-duplicated-rows/23734>\
**Category:** General Usage\
**Tags:** juliadb\
**Created:** [May 1, 2019, 1:35pm UTC](https://discourse.julialang.org/t/remove-duplicated-rows/23734 "2019-05-01T13:35:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![alphasig329](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/alphasig329/32/9794_2.png) [@alphasig329](https://discourse.julialang.org/u/alphasig329)\
**Post date:** [May 1, 2019, 1:35pm UTC](https://discourse.julialang.org/t/remove-duplicated-rows/23734/1 "2019-05-01T13:35:35Z")

</div>

Is there a function like R’s `unique` with JuliaDB to remove duplicated rows?

---

<div class="post-metadata">

**Author:** ![yakir12](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/yakir12/32/297_2.png) [@yakir12](https://discourse.julialang.org/u/yakir12)\
**Post date:** [May 1, 2019, 1:52pm UTC](https://discourse.julialang.org/t/remove-duplicated-rows/23734/2 "2019-05-01T13:52:23Z")

</div>

Does `unique!(rows(t))` work for you?

---

<div class="post-metadata">

**Author:** ![alphasig329](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/alphasig329/32/9794_2.png) [@alphasig329](https://discourse.julialang.org/u/alphasig329)\
**Post date:** [May 1, 2019, 4:35pm UTC](https://discourse.julialang.org/t/remove-duplicated-rows/23734/3 "2019-05-01T16:35:52Z")

</div>

Yes, this `table(unique!(rows(impt_data)))` worked.