In my table i have duplicate rows. i want to get distinct rows.
select distinct * from table1 does not work.
select distinct col1,col2,col3,col4 from table1 does not work.
both say: The text data type cannot be selected as DISTINCT because it is not comparable.
select distinct(col1) col2,col3,col4 from table1 is working.But the data of col1 shows under the name of col2. The data which should come under col2 is now showing.
PLZ help me to solve this