How do I get a list from an SQL query and let the user select the option from the list?

[#1]

Do you have SQL query as a string? In Query Builder? SQL Query result in JMP data table? Or possibly something else?

[#2]

It is a column name with multiple parameters.

For example, I have a column named fruits and there are apple, mango and orange.

multiple data for each fruits and would like to filter the column where the user can select if he wants to see apple, mango or orange data 

[#3]

You can maybe use just data filter

or build some more customized U using different options such as list box, check box, radio box...

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");

nw = New Window("Example",
	H List Box(
		lb = List Box(:name << get values),
		rb = Check Box(:name << get values),
		cb = Radio  Box(:name << get values)
	)
);