# Vision DropDown Component - How to Limit Query results that match

**URL:** <https://forum.inductiveautomation.com/t/vision-dropdown-component-how-to-limit-query-results-that-match/109508>\
**Category:** Ignition\
**Tags:** ignition81, vision\
**Created:** [August 7, 2025, 10:36pm UTC](https://forum.inductiveautomation.com/t/vision-dropdown-component-how-to-limit-query-results-that-match/109508 "2025-08-07T22:36:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![McLendon\_Automation](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mclendon_automation/32/78325_2.png) [@McLendon\_Automation](https://forum.inductiveautomation.com/u/McLendon_Automation)\
**Post date:** [August 7, 2025, 10:36pm UTC](https://forum.inductiveautomation.com/t/vision-dropdown-component-how-to-limit-query-results-that-match/109508/1 "2025-08-07T22:36:00Z")

</div>

I am trying to Use a Vision Dropdown box with a SQL Query binding to fill in it's possible selections.

I am getting valid results, only when multiple rows contain the same value the dropdown box displays a selection item for each row.

 ![Dropdown multiples](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/8/c8fed66fb0bbc4012468977ec2376e0cc49b5ff5.png)

Here is my SQL Query Binding for the Drop Down.

 ![DropDown SQL Query Binding](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/e/7ebdf96b8bc2a8682f6207dcd90dffaefdf8acd0.png)

And also for reference, here are the Drop Down properties.

 ![DropDown Property Editor](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/b/6b3bbe5054f11ae73e6cb04a785a0bb61a2cd578.png)

How do i setup this dropdown so even if there are hundreds (which there will be) of Batch numbers that match only one will be displayed for each unique value?

---

<div class="post-metadata">

**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\
**Post date:** [August 7, 2025, 10:41pm UTC](https://forum.inductiveautomation.com/t/vision-dropdown-component-how-to-limit-query-results-that-match/109508/2 "2025-08-07T22:41:55Z")

</div>

Since you are only pulling from one column, use [`SELECT DISTINCT`](https://www.w3schools.com/sql/sql_distinct.asp)