Page 1 of 1
How to get distinct values?
Posted: Sun Mar 16, 2008 5:07 am
by nadia
Hi,
I've a report query and i want to get the distinct values of each column in this query, is there a way to do this?
I've oracle 10g and reports 6i.
Regards
Posted: Sun Mar 16, 2008 9:19 am
by admin
Use distinct in your query,
Select distinct id, name from employees;
Posted: Mon Mar 17, 2008 4:55 am
by nadia
Hi,
Thanks for your reply.
I want the unique values for each column separately. The output will be like this :
IND_TIME_YEAR: 2007, 2008
IND_TIME_MONTH: 1,2,3,7,8
CON_ID: 123,234,345
GVN_ID: 098,087
Regards,
Posted: Sat Apr 05, 2008 5:11 pm
by mirza_rehan
Asslaam-o-Alaikum,
Nadia sorry for late reply.
please send me yours table structure and also send me report format and required columns
regards
Rehan Mirza
+971-50-1792629