Distinct Value in Value Set

How to get distinct value for any column in value set.
E.g Table is emp, to Type value set for job then in lov it has to display distinct job.

Questions by bhushan.oracle

Showing Answers 1 - 2 of 2 Answers

Bhaskar Bethi

  • Aug 12th, 2011
 

select PERIOD_YEAR
from gl_periods
where rowid in (select max(rowid) from gl_periods group by
PERIOD_YEAR )
order by PERIOD_YEAR

Follow the same with required table.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions