Display only distinct records and sorting in dropdown

[Sean]

Hi,

I am facing a problem and would like to know whether it is possible to do so.

i am retrieving a refcursor which has a list of last names, first names, address, city, state, and zip.

I pick up this information and populate a dropdown list. I was wondering if it is possible to pick up distinct records, and sort them out by last name?

Suggestions are welcomed.

--
Thank You,
Sean

[copyco]

If you're asking about what the command text, or SQL statement would be
to do this, it would be this:

"select distinct last_name, first_name, address, city, state, zip
from whatever_my_table_is
group by last_name, first_name, address, city, state, zip
order by last_name, first_name"

Sean wrote:

Hi,

I am facing a problem and would like to know whether it is possible to
do so.

i am retrieving a refcursor which has a list of last names, first names,
address, city, state, and zip.

I pick up this information and populate a dropdown list. I was wondering
if it is possible to pick up distinct records, and sort them out by last
name?

Suggestions are welcomed.

--
Thank You,
Sean