Hello all,
I want to display distinct values in the dropdown box. This is the query I am using:
select distinct db_document_type_desc, db_document_type_id
from database_document_type
order by 1
The query above returns duplicate values because db_document_type_id for each db_document_type_desc record is unique.
How can I accomplish it?
Thanks.