How to get distinct values?

[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

[admin]

Use distinct in your query,

Select distinct id, name from employees;

[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,

[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