sql to eliminate duplicate values

[anandkl]

Hi friends,
I have two columns which contain duplicate values

cl c2
1 a
1 a
1 a
2 b
2 b
2 b
3 c
3 c
3 c

Now i want to select distinct from these two columns.

please give the query.I know that its simple but please help me.

regards
anandkl

[feroz]

Hi,

try this:

select distinct c1,c2 from tablename;

hope this help you.

regards,
feroz

[Jr]

select distinct c1||c2 from tablename;


thanx
Jr.