Not allowing duplicate values to an array
 

Hi,
How can I prevent duplicate values from getting stored into an array? I am trying to dynamically populate an array with data using the concat() function, but I do not want to allow duplicate selection to be stored in the array. Total noob here. Pls help! Thanks.

you need to sort the array and then check for duplicates.hope this would work or let me know if not working still

that would be easy if you have ID on every record. So load this on your array:
select distinct(id) from table1
hope that helps.

If you unique Id for each record,it wont allow the duplicates..