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.

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.

sridutta

 Profile Answers by sridutta Questions by sridutta

• Dec 8th, 2008

Use select distinct column name from table instead of table name

Answer Question  Select Best Answer