# Query using Distinct

**URL:** <https://forum.inductiveautomation.com/t/query-using-distinct/6417>\
**Category:** General Discussion\
**Created:** [May 8, 2013, 10:35pm UTC](https://forum.inductiveautomation.com/t/query-using-distinct/6417 "2013-05-08T22:35:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![emca222](https://avatars.discourse-cdn.com/v4/letter/e/a4c791/32.png) [@emca222](https://forum.inductiveautomation.com/u/emca222)\
**Post date:** [May 8, 2013, 10:35pm UTC](https://forum.inductiveautomation.com/t/query-using-distinct/6417/1 "2013-05-08T22:35:09Z")

</div>

I cannot use the key word Distinct when using the Query Browser without causing an exception  
(incorrect syntax near the keyword ‘distinct’ ) is there an alternative word to achieve the same result.

---

<div class="post-metadata">

**Author:** ![James.Lorenz](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/james.lorenz/32/3290_2.png) [@James.Lorenz](https://forum.inductiveautomation.com/u/James.Lorenz)\
**Post date:** [May 8, 2013, 11:34pm UTC](https://forum.inductiveautomation.com/t/query-using-distinct/6417/2 "2013-05-08T23:34:53Z")

</div>

This is an outstanding bug with the query browser. However, you can use DISTINCT in queries within your Ignition project without issues. If you want to test queries with DISTINCT in them, you’ll have to use the respective UI tool of your DB for the time being.